From bellis@hsph.harvard.edu  Mon Aug 20 19:45:33 2001
From: bellis@hsph.harvard.edu (Byron Ellis)
Date: Mon, 20 Aug 2001 14:45:33 -0400 (EDT)
Subject: [Rd] Excel -> *.CSV in Unix (Linux) command line?
In-Reply-To: <15233.15643.232282.557687@mithrandir.hornik.net>
Message-ID: <Pine.GSO.4.10.10108201442190.3905-100000@hsph.harvard.edu>

On Mon, 20 Aug 2001, Kurt Hornik wrote:
> 
> Martin,
> 
> One remark.  If we think we want to be able to import Excel data
> directly into R then neither solution will do I think: the xls2csv
> program from (2) is not good enough, and the other solutions require
> tools that may not be available.  (Effort is currently put into removing
> run-time and even build-time dependency on Perl and shell tools, and use
> R scripts instead.)
> 
> I think it would be nice if package `foreign' had at least limited
> support for reading in .xls files ...

There is complete documentation for the Excel format (BIFF I think its
called) in the Excel SDK--- I'm not sure where you get it (it is probably
on one of the MSDN CDs somewhere, but it doesn't appear to be on the
website). For Excel 2002 (aka ExcelXP) as with most of the MS OfficeXP 
line, they've added native XML support making reading/writing files much
less of a problem.


 > > -k
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-devel-request@stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 

Byron Ellis (bellis@hsph.harvard.edu)
"Oook" - The Librarian



-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-devel-request@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._


[Rd] Excel -> *.CSV in Unix (Linux) command line?
Byron Ellis