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

[Liaw, Andy]

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