[R] writing to .xlsx

Gabor Grothendieck ggrothendieck at gmail.com
Wed Jan 9 21:45:21 CET 2013

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

More information about the R-help mailing list