If you are exporting your dataframes to Excel on Windows and
if you have Excel installed and
if you are willing to make your hands dirty by programming VBA
(the programming language built into Excel) and
if you are willing to install RExcel
(by way of the CRAN package RExcelInstaller or by
You also could use RExcel and write some VBA macros doing this task for you.
You can essentially have the rcom R-centric solution or the
VBA-centric RExcel solution.
On Jul 14, 2010, at 12:19 AM, Marc Schwartz wrote:
If I am correctly understanding what Eugen is trying to do, WriteXLS() won't
It isn't beautiful, but I use this package to write excel files from linux.
http://github.com/armstrtw/Rexcelpoi
the basic idea is that each element of a list is written as a separate
sheet, but if a list element is itself a list, then all the elements
of that list are written to the same sheet
Hello R-users,
Checking the archives, I recently came across this topic:
export tables to Excel files
(http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679),
and the following interesting references have been proposed:
Check the WriteXLS package, I think it does that and also saves
each R object on a different excel sheet.
Felipe D. Carrillo
Supervisory Fishery Biologist
Department of the Interior
US Fish Wildlife Service
California, USA
- Original Message
From: eugen pircalabelu
If I am correctly understanding what Eugen is trying to do, WriteXLS() won't
get him there. WriteXLS() will enable you to label/name the worksheets (tabs)
but not allow you to precede the actual data frame rows and columns on the
sheet with a title or label.
I suspect that you may have to look
On Tue, Jul 13, 2010 at 4:21 PM, eugen pircalabelu
eugen_pircalab...@yahoo.com wrote:
Hello R-users,
Checking the archives, I recently came across this topic:
export tables to Excel files
(http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679),
and the following
7 matches
Mail list logo