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]]

