Dieter Menne wrote:
stephen sefick <ssefick <at> gmail.com> writes:
I have searched the archives and I did not find the answer to my
question. Is there a way to read in a .odf spreadsheet without
modification to a .csv file. I am analyzing my classes scores on
their first exam, and would like to read the grade book in without
converting it to .csv.
For very simple cases, i.e. only numbers and headers, it is possible to extract
content.xml from the odf (rename it to .zip to see it), and read the required
items with package XML. This is very fast and works well for large, but strictly
structured data.
Indeed. I just put a package ROpenOffice up at
http://www.omegahat.org/ROpenOffice
which provides a read.ods() function and can read worksheets
in a workbook, even those that are not rectangular.
This uses the Rcompression package to read the .ods archive.
I'll eventually coordinate it with the same facilities we have
in the RExcelXML and ROOXML packages which do this
and a few other things for xlsx files for Excel.
D.
Dieter
______________________________________________
R-help@r-project.org mailing list
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.
______________________________________________
R-help@r-project.org mailing list
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.
