[R] Update of xlsReadWrite package

Hans-Peter gchappi at gmail.com
Fri Apr 27 15:42:14 CEST 2007

The (*windows only*) xlsReadWrite package has been updated and the new
version is available on CRAN.

xlsReadWrite natively reads and writes Excel files (v97 - 2003).

o Changes from v1.1.1 to v1.3.3 (versions between never really published)

  - ROWNAMES-support also for matrices (not only for data.frame)
  - explicit rowNames argument in interface.
        (stimulated by email Adrian Dusa)

  - support for DATE and TIME values: Excel date and/or time values can
    be retrieved as ISO-8601 format string.
    - Either explicitly with the colClasses entries:
      - "isodate" as "YYYY-MM-DD"
      - "isotime" as "hh:mm:ss"
      - "isodatetime"as "YYYY-MM-DD hh:mm:ss"
    - Or for data.frame an eventual date/time type can be automatically
      determined from the value(s) of the first Excel row (determined from
      the cell formatting as there are no real date types in Excel)

   - There are four DATE CONVERSION ROUTINES (taken from pro) which enable
     you to work with Excel date/times values:
     - dateTimeToStr     converts an ole datetime value to a string
     - strToDateTime     vice versa (depends on local settings)
     - dateTimeToIsoStr  }
     - isoStrToDateTime  } independent of local settings
        (date/time support stimulated by an email of Gabor Grothendiek)

  - new argument "stringsAsFactors = default.stringsAsFactors()"
        (proposed by Peter Cock)
    Remark: this is a *potentially code breaking change*.
            Until now strings have been retrieved as characters.

  - new argument "checkNames = TRUE"
        (proposed by Peter Cock)

  - colClasses entries modified:
    - "numeric" and "factor added,
    - "rowname" removed (is now a proper argument)
    - scalar values will be recycled (proposed by David Kinniburgh)
  - if explicit colClasses have not been given, the colClasses will
    be determined from the first 16 Excelrows)
        (stimulated by email David Kinniburgh)

  - empty cells for double columns come now as NA (before it was 0)

  - factors now handled in the Delphi (calls R function as.factor)
  - matrix output-type otFactor removed (not used)
  - fixed NA factors bug (thanks to Mark W. Kimpel)
  - range checks disabled again (flexcel needs this)
  - some other small fixes

o Function declarations as per v1.3.2
  - read.xls( file,
              colNames = TRUE,
              sheet = 1,
              type = "data.frame",
              from = 1,
              rowNames = NA, colClasses = NA, checkNames = TRUE,
              dateTimeAs = "numeric",
              stringsAsFactors = default.stringsAsFactors() )

  - write.xls( x, file,
               colNames = TRUE,
               sheet = 1,
               from = 1,
               rowNames = NA )

  - dateTimeToStr( odate, format = "" )
  - strToDateTime( sdate )
  - dateTimeToIsoStr( odate, isoformat = "YYYY-MM-DD hh:mm:ss" )
  - isoStrToDateTime( sdate )

o Download

  - CRAN (v1.3.2; from within RGui) or
  - http://treetron.googlepages.com/ (v1.3.3)
    - direct link to package:
    - direct link to test-/demoscripts:

  - the testscript is used for our internal "unittests". It will show
you many examples of how to use the package.

Comments and suggestions are welcome.
Hope you enjoy using xlsReadWrite!


More information about the R-help mailing list