Re: [R] howto import .xls and .ods

2008-05-11 Thread Hans Ekbrand
On Fri, May 02, 2008 at 07:35:37AM +0100, Prof Brian Ripley wrote: > There is a *manual* on R Data Import/Export, not just an FAQ. > > This is the first request I have seen for .ods (whatever that is -- The most well-known application that uses this file format is the Calc (Spreadsheet) part of

Re: [R] howto import .xls and .ods

2008-05-01 Thread Prof Brian Ripley
There is a *manual* on R Data Import/Export, not just an FAQ. This is the first request I have seen for .ods (whatever that is -- please don't assume that a file type is determined by an extension, and we not infrequently get asked about CSV files with extension .xls). On Thu, 1 May 2008, Abh

Re: [R] howto import .xls and .ods

2008-05-01 Thread Gabor Grothendieck
read.xls in the gdata package can read xls files. It uses a perl program and does not require Windows. There is also the related xls2csv in the same package. On Thu, May 1, 2008 at 5:00 PM, Jonas Stein <[EMAIL PROTECTED]> wrote: > Hi, > > i want to import data from .ods and .xls files in R on a

Re: [R] howto import .xls and .ods

2008-05-01 Thread Abhijit Dasgupta
I've written a little python script that converts ods and xls to csv, and a wrapper in R that imports a sheet of the ods and/or xls into a data.frame in R. If this is a FAQ and there is an existing solution, great. Actually, for xls, the library gdata has a read.xls function that uses a perl f

[R] howto import .xls and .ods

2008-05-01 Thread Jonas Stein
Hi, i want to import data from .ods and .xls files in R on a linux system. Seems it was a faq in the past, but i found only solutions for Windows. Is there a handy solution for linux? The best would be something like mytab <-read.ods(...) Any hints? Thanks a lot for reading so far, -- Jonas S