Re: [R] Reading an excel file

2019-01-10 Thread rsherry8
The way I have done it in the past is to convert to an CSV file. One advantage of this approach is that should my r script accidental write to the file, my original Excel file is not damaged. Bob Sherry On 1/10/2019 4:39 PM, Bernard Comcast wrote: What is the best way to read in data of any

Re: [R] Reading an excel file

2019-01-10 Thread Albrecht Kauffmann
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 alkau...@fastmail.fm Am Do, 10. Jan 2019, um 22:43, schrieb

Re: [R] Reading an excel file

2019-01-10 Thread Bert Gunter
Don't! Well, I know that being a wiseguy is not helpful, but this "advice" is actually not entirely unhelpful. Search on "input Excel file" or similar on rseek.org to bring up many links, including the readxl package, tutorials, the R data import/export manual, etc. However, excel files are

Re: [R] Reading an excel file

2019-01-10 Thread 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 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

[R] Reading an excel file

2019-01-10 Thread Bernard Comcast
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@r-project.org mailing list -- To UNSUBSCRIBE and more, see