R help - Dec 2012 - error reading xlsm file with read.xls

Dear all,

I cannot reading a .xlsm file using read.xls.

I executed:

read.xls("resultados.xlsm",
colNames = TRUE,
sheet = 1,
type = "data.frame",
from = 1,
rowNames = NA,
colClasses = "character",
checkNames = TRUE,
dateTime = "numeric",
naStrings = NA,
stringsAsFactors = F)
Error:

Call("ReadXls", file, colNames, sheet, type, from, rowNames, :
Incorrect number of arguments (11), expecting 10 for 'ReadXls'
If I just write

read.xls("resultados.xlsm")
It give me the same error.

Regards,

Sebastián.

	[[alternative HTML version deleted]]

On Dec 4, 2012, at 10:05 AM, Sebastian Kruk wrote:
> Dear all,
> 
> I cannot reading a .xlsm file using read.xls.
> 
That doesn't surprise me. It's a macro format. Why should R be reading
Excel macros?

> I executed:
> 
> read.xls("resultados.xlsm",
> colNames = TRUE,
> sheet = 1,
> type = "data.frame",
> from = 1,
> rowNames = NA,
> colClasses = "character",
> checkNames = TRUE,
> dateTime = "numeric",
> naStrings = NA,
> stringsAsFactors = F)
> Error:
> 
> Call("ReadXls", file, colNames, sheet, type, from, rowNames, :
> Incorrect number of arguments (11), expecting 10 for 'ReadXls'
> If I just write
> 
> read.xls("resultados.xlsm")
> It give me the same error.
-- 

David Winsemius, MD
Alameda, CA, USA