Re: [R] Reading microsoft .xls format and openoffice OpenDocument files

From: Liaw, Andy <andy_liaw_at_merck.com>
Date: Mon, 10 Mar 2008 11:29:10 -0400

I don't have answer to either of your questions, just some info:

  1. Why not try the XLSReadWrite package that can do it natively without using Perl to convert to CSV first?
  2. There seems to be an Ooo extension that sounds similar to R-Excel (connecting R to Calc). Not sure if that helps you any though.

Andy

From: Ajay Shah
>
> 1. I have used gdata::read.xls() with much happiness. But every now
> and then it breaks. I have not, as yet, been able to construct a
> mental model about the class of .xls files for which it works. Does
> someone have a simple rule for predicting the circumstances under
> which it will work?
>
> 2. Just like there is a read.xls(), it'd be great if we have a
> read.ods() which directly reads files from openoffice. This should
> be easier than grokking Microsoft formats given that openoffice is
> gpl. I hunted a bit and couldn't find any. Does someone know how we
> might approach this?
>
> Am I correct in thinking that our goal is reading OpenDocument
> files (http://en.wikipedia.org/wiki/OpenDocument) ?
>
> --
> Ajay Shah
> http://www.mayin.org/ajayshah
> ajayshah_at_mayin.org
> http://ajayshahblog.blogspot.com
> <*(:-? - wizard who doesn't know the answer.
>
> ______________________________________________
> 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.
>
>
>



Notice: This e-mail message, together with any attachme...{{dropped:15}}

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 Mon 10 Mar 2008 - 15:32:19 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 Mon 10 Mar 2008 - 16:30:22 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