[R] open xlsx file using read.xls function of gdata package

[Keith S Weintraub]

Will it work with .xlsm files?

Best,
KW

> You might try the readxl package - it's only available on github but it
> reads both xlsx and xls. All going well, it should be on its way to CRAN
> next week.
> 
> Hadley
> 
> On Friday, April 3, 2015, Luigi Marongiu <marongiu.luigi at gmail.com> wrote:
> 
>> Dear all,
>> I am trying to open excel files using the gdata package. I can do that
>> using a .xls file, but the same file, containing the same data,
>> formatted in .xlsx gives error (R does not recognize the pattern from
>> where to start reading the data).
>> Doen anybody knows whether it is possible to read .xlslx with this package?
>> Am I missing another package to implement the reading of the .xlsx?
>> Thank you
>> Luigi
>> 
>> PS: this is the error I get:
>>> my.file <- "array.xlsx"
>>> my.data<-read.xls(
>> +       my.file,
>> +       sheet="sheet x",
>> +       verbose=FALSE,
>> +       pattern="row name",
>> +       na.strings=c("NA","#DIV/0!"),
>> +       method="tab",
>> +       perl="perl"
>> +     )
>>> Warning message:
>> In read.xls(my.file, sheet = "sheet x", verbose = FALSE,  :
>>  pattern not found
>> 
>> 
>> The verbose version runs like this:
>>    ?array.xlsx?
>> to tab  file
>>    ?/tmp/Rtmp2tAjzz/filef06102dd018.tab?
>> ...
>> 
>> Executing ' '/usr/bin/perl'
>> '/home/gigiux/R/x86_64-pc-linux-gnu-library/3.0/gdata/perl/xls2tab.pl'
>> 'array.xlsx' '/tmp/Rtmp2tAjzz/filef06102dd018.tab' 'sheet x' '...
>> 
>> Loading 'array.xlsx'...
>> Done.
>> 
>> Orignal Filename: array.xlsx
>> Number of Sheets: 2
>> 
>> Writing sheet 'sheet x' to file '/tmp/Rtmp2tAjzz/filef06102dd018.tab'
>> Minrow=31 Maxrow=17310 Mincol=0 Maxcol=4
>>  (Ignored 0 blank lines.)
>> 
>> 0
>> 
>> Done.
>> 
>> Searching for lines tfntaining pattern  row name ...
>> Warning message:
>> In read.xls(my.file, sheet = "sheet x", verbose = TRUE,  :
>>  pattern not found
>>> 
>> 
>> ______________________________________________
>> R-help at r-project.org <javascript:;> mailing list -- To UNSUBSCRIBE and
>> more, see
>> 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.
> 
> 
> 
> -- 
> http://had.co.nz/
> 
> 	[[alternative HTML version deleted]]
> 
> 


---
KW