An embedded and charset-unspecified text was scrubbed... Name: no disponible URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121204/7ba1c927/attachment.pl>
error reading xlsm file with read.xls
3 messages · Sebastian Kruk, David Winsemius
1 day later
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
On Dec 5, 2012, at 2:19 PM, David Winsemius wrote:
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)
The other point I would make is that you should be looking at the help page for read.xls and making sure that on the off-chance that the authors did intend for you to have access to Excel macros for some readsin in R tha thtey were using the same aruments. The error message says you are having problems with you argument list and looking at the help page makes me think you are using read.tabe arguments for read.xls. Not a wise idea.This is the list of formals: read.xlsx(file, sheetIndex, sheetName=NULL, rowIndex=NULL, colIndex=NULL, as.data.frame=TRUE, header=TRUE, colClasses=NA, keepFormulas=FALSE, encoding="unknown", ...) And it says the 'dots' are sent to data.frame rather than to read.table.
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
______________________________________________ R-help at 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.
David Winsemius, MD Alameda, CA, USA