[R] Reading an excel file

Albrecht Kauffmann @lk@uffm @ending from f@@tm@il@fm
Thu Jan 10 23:14:52 CET 2019


read.xlsx() works well if the xlsx-file has not too much joined cells. Particularly in the latter case I would recommend to convert the xlsx-file into csv format and then read.csv().

Greetings
Albrecht

-- 
  Albrecht Kauffmann
  alkauffm using fastmail.fm

Am Do, 10. Jan 2019, um 22:43, schrieb Hasan Diwan:
>  https://cran.r-project.org/web/packages/xlsx/xlsx.pdf
> 
> You'll need the JDK (>= 1.6) -- H
> 
> On Thu, 10 Jan 2019 at 13:40, Bernard Comcast <mcgarvey.bernard using comcast.net>
> wrote:
> 
> > What is the best way to read in data of any type from an Excel 2016 .xlsx
> > file?
> >
> > Thanks
> >
> > Bernard
> > Sent from my iPhone so please excuse the spelling!"
> > ______________________________________________
> > R-help using 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.
> >
> 
> 
> -- 
> OpenPGP:
> https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1
> If you wish to request my time, please do so using
> *bit.ly/hd1AppointmentRequest
> <http://bit.ly/hd1AppointmentRequest>*.
> Si vous voudrais faire connnaisance, allez a *bit.ly/hd1AppointmentRequest
> <http://bit.ly/hd1AppointmentRequest>*.
> 
> <https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1>Sent
> from my mobile device
> Envoye de mon portable
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help using 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.



More information about the R-help mailing list