An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20130109/0104204d/attachment-0001.pl>
writing to .xlsx
5 messages · jim holtman, Gabor Grothendieck, Marc Schwartz +1 more
Can you use '.xls' format files? If so, XLConnect works pretty good for those. If you are using '.xlsx' format (zip files internally), XLConnect takes much more CPU and memory to handle them. 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
[[alternative HTML version deleted]]
______________________________________________ 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.
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.
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
On Jan 9, 2013, at 2:45 PM, Gabor Grothendieck <ggrothendieck at gmail.com> wrote:
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.
Thanks for the referral Gabor. If Benjamin needs the xlsx format due to the larger dimensions supported, WriteXLS, since it writes xls format files, would not likely be suitable. Otherwise, of course, current versions of Excel can open the older format. If Benjamin simply needs to dump larger (for some definition of larger) datasets externally in format that is compatible with Excel, he could write out CSV files that, of course, can then be opened in Excel. That presumes that he is not looking to do any other formatting of the worksheets or other similar functionality that is native to Excel. Regards, Marc Schwartz
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20130109/6e9cfbbe/attachment-0001.pl>