[R] writing to .xlsx

[Gabor Grothendieck]

On Wed, Jan 9, 2013 at 2:19 PM, Benjamin Caldwell
<btcaldwell at berkeley.edu> wrote:
> Dear r helpers;
>
> I'm interested in reading from and writing to large .xlsx files fairly
> regularly.  (Why, the naysayers may ask - and the answer is basically
> colleagues and clients who prefer that format). I've tried out the
> XLConnect and xlsx libraries, but the java implementation they use just
> takes too much RAM for the files I'm working with.
>
> gdata leverages perl and works really well for reading in those files, so
> half the problem is solved for me! I don't see anything in the
> documentation about writing .xlsx, though. Is anyone aware of any libraries
> or clever solutions in R that would get the job done for me? I see a couple
> packages on CPAN for writing an xlsx, so it's been done in perl; perhaps it
> would be easy to run that from R? I don't use perl myself (yet?).
>
> Looking for recommendations.
>
> Best
>
> Ben Caldwell

Check out
http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel
and in particular the WriteXLS package can write Excel 2003 files
(xls) using perl.


--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com