Message-ID: <0F1D689E-0583-426E-ABB4-BC3E6A2A7C2D@comcast.net>
Date: 2012-12-05T22:19:23Z
From: David Winsemius
Subject: error reading xlsm file with read.xls
In-Reply-To: <CAMn86Nd_MF5R0FPLCsbff61mhPBMmEbXP6R=va0TzWwiTqDwng@mail.gmail.com>
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