Creating an Excel file with multiple spreadsheets
I do not believe that anything formal has been done. Calling the perl script within an R function call would not be overly difficult, the key would be to package the perl modules required by the script, otherwise the user would have to install these manually from CPAN or via an OS specific package management system. I would also note that I recently posted an updated version of the script here: https://stat.ethz.ch/pipermail/r-help/2009-March/190327.html which generalizes the script to use the updated version of Spreadsheet::WriteExcel, overcoming the prior file size limit and also better handles UTF-8 encoding, which the prior version did not do properly. HTH, Marc Schwartz
On Mar 9, 2009, at 5:03 PM, Gabor Grothendieck wrote:
It was from Greg, not me. On Mon, Mar 9, 2009 at 5:53 PM, Carl Witthoft <carl at witthoft.com> wrote:
Just wondering -- the referenced thread at [1] http://tinyurl.com/aurprr included a comment from Gabor (I think) that some day the gdata package might include a 'write.xls' based on M Schwartz' perl script. Any progress there? Carl