Re: [R] Writing Excel (.xls) files on non-Windows OSs using Perl

2007-07-10 Thread Marc Schwartz
Greg, You are certainly welcome to use my Perl script as the basis for a write.xls() function for gdata. You can even change the name of the script to csv2xls.pl if you wish, for consistency with the existing function. If you might want to use the script largely 'as is', I won't have time for a

Re: [R] Writing Excel (.xls) files on non-Windows OSs using Perl

2007-07-09 Thread Hans-Peter
Hi, 2007/7/8, Marc Schwartz [EMAIL PROTECTED]: [snip] There exists the xlsReadWrite package on CRAN by Hans-Peter Suter, which is restricted to Windows, since it utilizes the non-FOSS MS Office API to write the Excel formats. The non-FOSS API is not the problem(#) but its implementation is:

Re: [R] Writing Excel (.xls) files on non-Windows OSs using Perl

2007-07-09 Thread Marc Schwartz
On Mon, 2007-07-09 at 16:42 +0300, Hans-Peter wrote: Hi, 2007/7/8, Marc Schwartz [EMAIL PROTECTED]: [snip] There exists the xlsReadWrite package on CRAN by Hans-Peter Suter, which is restricted to Windows, since it utilizes the non-FOSS MS Office API to write the Excel formats. The

Re: [R] Writing Excel (.xls) files on non-Windows OSs using Perl

2007-07-09 Thread Gabor Grothendieck
Note that there already is a function, read.xls, in gdata that uses Perl. On 7/9/07, Marc Schwartz [EMAIL PROTECTED] wrote: On Mon, 2007-07-09 at 16:42 +0300, Hans-Peter wrote: Hi, 2007/7/8, Marc Schwartz [EMAIL PROTECTED]: [snip] There exists the xlsReadWrite package on CRAN by

Re: [R] Writing Excel (.xls) files on non-Windows OSs using Perl

2007-07-09 Thread Uwe Ligges
Gabor Grothendieck wrote: Note that there already is a function, read.xls, in gdata that uses Perl. Note that Marc talked about *writing* in his original message. Uwe Ligges On 7/9/07, Marc Schwartz [EMAIL PROTECTED] wrote: On Mon, 2007-07-09 at 16:42 +0300, Hans-Peter wrote: Hi,

Re: [R] Writing Excel (.xls) files on non-Windows OSs using Perl

2007-07-09 Thread Gregory Warnes
Since I wrote the xls2csv.pl and read.xls() code for gdata, a perl module for writing MS-Excel files has come on the scene. I don't have the time at the moment to create an csv2xls.pl file, but it should be straightforward, and I would gladly add it to the gdata package. -G On Jul 9,

[R] Writing Excel (.xls) files on non-Windows OSs using Perl

2007-07-08 Thread Marc Schwartz
Hi all, There have been quite a few threads in the recent months pertaining to the ability to directly write native Excel (.xls) files from R. For example, exporting R matrices and/or data frames to an Excel file, with perhaps the ability to create multiple tabs (worksheets) within a single file,