[R-pkgs] WriteXLS Version 3.0.0 Released

Marc Schwartz marc_schwartz at me.com
Fri Jul 19 17:40:59 CEST 2013


Hi all,

Version 3.0.0 of the WriteXLS package has been released to CRAN. Source tarballs are being mirrored and binaries for Windows and OSX should appear in due course.

Main CRAN URL: http://cran.r-project.org/web/packages/WriteXLS/index.html

WriterXLS is a cross-platform Perl based R function to create Excel 2003 (XLS) and Excel 2007 (XLSX) 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.

The key changes in the new version are:

1. The ability to create Excel 2007 (XLSX) files in addition to Excel 2003 (XLS) files.

2. The Perl package Excel::Writer::XLSX is now included to facilitate the creation of the Excel 2007 files.

3. The Perl package Text::CSV_XS has been replaced with Text::CSV_PP, which is a Pure Perl implementation of the former package and is included in the WriteXLS package. This should make it easier for users to install WriteXLS since a pre-compiled or locally compiled binary for Text::CSV_XS is no longer required.

4. Data frame columns that have a 'comment' attribute, created using the comment() function, will have the text content of the 'comment' attribute written to a cell comment in the first row of the worksheet containing that data frame. This will work for both Excel 2003 (XLS) and Excel 2007 (XLSX) files. These comments can serve as column labels, providing descriptive information on the content of the column in the Excel worksheet.


The package is openly maintained under GPL-2 at:

  https://github.com/marcschwartz/WriteXLS


If anyone identifies any issues, please let me know.

Thanks and regards,

Marc Schwartz



More information about the R-packages mailing list