[R] reading .odf spreadsheet into R

Gabor Grothendieck ggrothendieck at gmail.com
Tue Feb 3 16:14:18 CET 2009


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.
>




More information about the R-help mailing list