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 <btcaldw...@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@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. ______________________________________________ R-help@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.
