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
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
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
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
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
5 matches
Mail list logo