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@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.
