[R-pkgs] WriteXLS - New Version 2.0.1

Marc Schwartz marc_schwartz at me.com
Thu Sep 16 21:16:49 CEST 2010

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so.

It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls, where downloads will eventually be available as well. 

Package: WriteXLS

Version: 2.0.1

Description: Cross-platform Perl based R function to create Excel 2003 (XLS) files from one or more data frames. Each data frame will be written to a separate named worksheet in the Excel spreadsheet. The worksheet name will be the name of the data frame it contains or can be specified by the user.

Author(s): Marc Schwartz <marc_schwartz at me.com>
Maintainer: Marc Schwartz <marc_schwartz at me.com>

License: GPL (>=2)

Changes since version 1.9.0:

1. Major version update to 2.x.y
2. Added the ability to specify the name of a list that contains one or more data frames, in addition to the original vector of one or more data frame names.
3. Updated with newer versions of the included Perl modules.
4. Note that WorkbookBig.pm is no longer required and is therefore removed from the packaged Perl modules.
5. Fixed the underscores "_" in testPerl.Rd
6. Added check of the data frames for rows > 65536 and columns > 256.
7. Temporary CSV file names are now (1:number of data frames).csv
6. SheetNames are now always written to temporary file SheetNames.txt, so the '--SN' argument is deleted from the Perl script

The major user visible functional change is number 2, such that the name of a list can now be specified, where the list contains one or more data frames. An example of this use is:

 iris.split <- split(iris, iris$Species)
 WriteXLS("iris.split", "irissplit.xls")

This will result in 3 worksheets created in an Excel 2003 format XLS file called 'irissplit.xls'. The worksheet names will, by default, be names(iris.split), that is c("setosa", "versicolor", "virginica"). See the function help file for more details.


Marc Schwartz

More information about the R-packages mailing list