[R] xlsReadWrite 1.5.4 and xlsReadWritePro 1.6.4 released

Hans-Peter Suter gchappi at gmail.com
Tue Jan 25 15:36:21 CET 2011


The xlsReadWrite[Pro] package allows to natively read and write Excel
files (.xls) on the Win 32-bit platform.

Changes:

o fix bug with integer conversion (http://dev.swissr.org/issues/113)

  PROBLEM: values outside the integer range (i.e. 12345678901) didn't give an NA
           (and a warning message) but have been converted to a wrong value
  WHERE:
    - free/pro: reading an Excel sheet and explicitely defining:
'colClasses = "integer"'
      or 'type = "integer". It's assumed that only very few people do this.
    - pro: when (auto) detecting a data.frame column type for numeric
values the type becomes
      an 'integer' in some situations. This probably affects more
people than above
  SOLUTION:
    - an error will be raised for too large/small values (same as in read.table)
    - numeric data.frame column types default to 'double' (as in the
free version)

o adapt RUnit tests to new behaviour
o some small cosmetic changes

Credits to Gyorgy Ottucsak who found the problem in xlsReadWritePro
and send us a report (incl. testfile). Thanks a lot!

The new xlsReadWrite version will be submitted to CRAN in a moment.
Both updated packages are available now from www.swissr.org/download
or - full listing - here:
http://dl.dropbox.com/u/2602516/swissrpkg/index.html.

Cheers,
Hans-Peter



More information about the R-help mailing list