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@r-project.org 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.