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. thanks -- Stephen Sefick Let's not spend our time and resources thinking about things that are so little or so large that all they really do for us is puff us up and make us feel like gods. We are mammals, and have not exhausted the annoying little problems of being mammals. -K. Mullis
I don't know of an elegant solution - I store most of my data as
csv files so it can be easily accessed by all sorts of software
tools - but for small tasks you can can just copy it and then use
read.table("clipboard")
Sarah
On Mon, Feb 2, 2009 at 10:34 PM, stephen sefick <ssefick at gmail.com>
wrote:> 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.
> thanks
>
> --
> Stephen Sefick
>
--
Sarah Goslee
http://www.functionaldiversity.org
Using unoconv (http://dag.wieers.com/rpm/packages/unoconv/) might be a solution. stephen sefick wrote:> 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. > thanks > > > > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.176 / Virus Database: 270.10.17/1931 - Release Date: 2/2/2009 7:21 PM >-- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
I have not used it, but if you are at all comfortable with Perl, you might want to look at the Spreadsheet::Read module: http://search.cpan.org/~HMBRAND/Spreadsheet-Read/Read.pm There is a wiki article here: http://howto.wikia.com/wiki/Howto_read_OpenOffice_OpenDocument_spreadsheets_in_Perl that provides an overview of Perl options to read ODS files. HTH, Marc Schwartz on 02/03/2009 08:18 AM Erich Neuwirth wrote:> Using unoconv (http://dag.wieers.com/rpm/packages/unoconv/) > might be a solution. > > stephen sefick wrote: >> 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. >> thanks
If you do look at that you might be able to modify read.xls in gdata package. It uses perl code to read xls files so you would already have the infrastructure R code all set out for you. On Tue, Feb 3, 2009 at 10:09 AM, Marc Schwartz <marc_schwartz at comcast.net> wrote:> I have not used it, but if you are at all comfortable with Perl, you > might want to look at the Spreadsheet::Read module: > > http://search.cpan.org/~HMBRAND/Spreadsheet-Read/Read.pm > > There is a wiki article here: > > http://howto.wikia.com/wiki/Howto_read_OpenOffice_OpenDocument_spreadsheets_in_Perl > > that provides an overview of Perl options to read ODS files. > > HTH, > > Marc Schwartz > > on 02/03/2009 08:18 AM Erich Neuwirth wrote: >> Using unoconv (http://dag.wieers.com/rpm/packages/unoconv/) >> might be a solution. >> >> stephen sefick wrote: >>> 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. >>> thanks > > ______________________________________________ > R-help at 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. >
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. Dieter