[R] XLSM Question

From: Gabrielsen, Alexandros <A.Gabrielsen_at_city.ac.uk>
Date: Wed, 18 May 2011 08:58:28 +0100


Hi,  

I would like to ask you how to read an arrary from an *.xlsm file? I have tried different packages such as xlsReadWrite and RODBC. Everything is performed on the final versions of addons and R.  

Additionally, when I tried the RODBC received the following error:
> library(RODBC)

> con = odbcConnectExcel("C:\\Temp.xlsm")

Warning messages:

  1. In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :

[RODBC] ERROR: state HY000, code -5120, message [Microsoft][ODBC Excel Driver] External table is not in the expected format.

2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :

ODBC connection failed  

Many thanks,

Alexandros

        [[alternative HTML version deleted]]



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Wed 18 May 2011 - 08:23:24 GMT

This quarter's messages: by month, or sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

All messages

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 18 May 2011 - 08:50:07 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive