Re: [R] reading .odf spreadsheet into R

2009-02-04 Thread Duncan Temple Lang
Dieter Menne wrote: stephen sefick 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 th

Re: [R] reading .odf spreadsheet into R

2009-02-03 Thread Dieter Menne
stephen sefick 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 w

Re: [R] reading .odf spreadsheet into R

2009-02-03 Thread Gabor Grothendieck
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 wrote: > I have not used it, but if you are at all comfortable

Re: [R] reading .odf spreadsheet into R

2009-02-03 Thread Marc Schwartz
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 t

Re: [R] reading .odf spreadsheet into R

2009-02-03 Thread Erich Neuwirth
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 scor

Re: [R] reading .odf spreadsheet into R

2009-02-03 Thread Sarah Goslee
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 wrote: > I have searche

[R] reading .odf spreadsheet into R

2009-02-02 Thread stephen sefick
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 -- St