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

[Hadley Wickham]

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]]