Skip to content
Back to formatted view

Raw Message

Message-ID: <BCEE056A-F684-4E0D-95C1-775E26B733C3@mac.com>
Date: 2008-03-10T19:33:41Z
From: Gregory R. Warnes
Subject: Reading microsoft .xls format and openoffice OpenDocument files
In-Reply-To: <20080307111759.GE27511@lubyanka.local>

Hello Ajay,

I'm the author of the gdata package.  If you send me a copy of  
an .XLS file that doesn't work with read.xls(), I'll see about fixing  
the code.

-Greg




On Mar 7, 2008, at 6:17AM , Ajay Shah wrote:

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