error reading xlsm file with read.xls
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