[R] reading .odf spreadsheet into R

Dieter Menne dieter.menne at menne-biomed.de
Wed Feb 4 08:13:25 CET 2009

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.


More information about the R-help mailing list