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

2015-04-05 Thread 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 wrote: > >> Dear all, >> I am tryin

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

2015-04-03 Thread 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 wrote: > Dear all, > I am trying to open excel files using the gdata package. I can do that

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

2015-04-03 Thread Jeff Newmiller
I had poor luck with gdata. I have had better luck with XLConnect. There is no single best package for this, since each seems to leverage efforts made in other languages (so there are non-R configuration requirements to keep working) and Excel is a proprietary moving target. In general YMMV when

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

2015-04-03 Thread Luigi Marongiu
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