[R] error reading xlsm file with read.xls

[David Winsemius]

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