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

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Fri, 02 May 2008 07:35:37 +0100 (BST)

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, Abhijit Dasgupta wrote:

> 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
> function underneath.
>
> Abhijit Dasgupta, Ph.D
> Assistant Professor | Division of Biostatistics
> Dept of Pharmacology and Experimental Therapeutics | Thomas Jefferson
> University
> 1015 Chestnut St | Suite M100 | Philadelphia PA 19107
> Ph: (215) 503-9201 | Fax: (215) 503-3804
> adasgupt (at) mail (dot) jci (dot) tju (dot) edu
> ------------------------------------------------------------------------
> The documents accompanying this transmission may contain confidential health
> or business information. This information is intended for the use of the
> individual or entity named above. If you have received this information in
> error, please notify the sender immediately and arrange for the return or
> destruction of these documents.
> ------------------------------------------------------------------------
>
>
> Jonas Stein wrote:
>> 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,
>>
>>
>
> ______________________________________________
> 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.
>

-- 
Brian D. Ripley,                  ripley_at_stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________
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.
Received on Fri 02 May 2008 - 06:40:14 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sun 11 May 2008 - 22:30:37 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive