R help - Jul 2009 - help exporting to excel via xlsReadWritePro

I’m trying to export a file from R to excel using the xlsReadWritePro function
and I keep getting the error below.   I get the same error when I use the
oledatetime function.  My current date format is mm/dd/yyyy, which is how I want
it in excel.  Also is there anyway to export different datasets to  multiple
sheets similar to the ods function in SAS?
<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" />
library(xlsReadWritePro)
write.xls(rancho,file="H:\\Chris A\\Brain Injury\\Data\\rancho3.xls")
Error in write.xls(rancho, file = "H:\\Chris A\\Brain
Injury\\Data\\rancho3.xls") :
  "POSIXt" is not a valid entry (try:
unassigned/double/numeric/integer/logical/character/factor/NA/oledate/oletime/oledatetime/isodate/isotime/isodatetime/link/formula/mixed/mixedCharacter/mixedFactor)
 
 
write.xls(rancho,file="H:\\Chris A\\Brain
Injury\\Data\\rancho3.xls",dateTimeAs = "oledatetime")
Error in write.xls(rancho, file = "H:\\Chris A\\Brain
Injury\\Data\\rancho3.xls",  :
  "POSIXt" is not a valid entry (try:
unassigned/double/numeric/integer/logical/character/factor/NA/oledate/oletime/oledatetime/isodate/isotime/isodatetime/link/formula/mixed/mixedCharacter/mixedFactor)
 



Chris Anderson
707.315.8486
www.sassydeals4u.com
____________________________________________________________
Save on Criminal Lawyer Services. Click Now!
http://thirdpartyoffers.netzero.net/TGL2241/fc/BLSrjpYbd6x4nBy5Jx35gNadAcucOpjXKqZUZ0Ak7EUZFLp3rBhwqdFMHU8/
	[[alternative HTML version deleted]]

> I?m trying to export a file from R to excel using the xlsReadWritePro
function and I keep getting the error below.
POSIXt is not currently supported (neither in data.frames nor vectors)
and must be converted to other types (see ?write.xls). I almost never
use POSIXlt/ct myself but it would probably be a good idea to provide
support (I've added it as a request). Code:

dates <- c( "2009-07-02 19:30:00", "2009-07-02 19:31:15",
"2009-07-02
20:12:42" )
write.xls( data.frame( as.POSIXlt( dates ) ), "anothertestfile.xls" )
# gives error
write.xls( as.POSIXlt( dates ), "anothertestfile.xls" )
     # do.l
> [snip] Also is there anyway to export different datasets to ?multiple
sheets similar to the ods function in SAS?
Here is an example:

  # setup
library( "xlsReadWritePro" )
dates <- c( "2009-07-02 19:30:00", "2009-07-02 19:31:15",
"2009-07-02
20:12:42" )
mydat <- data.frame( idt = as.character( as.POSIXlt( dates ) ),
                     odt1 = isoStrToDateTime( dates ),
                     odt2 = isoStrToDateTime( dates ),
                     val = c( 1, 2, 3 ),
                     stringsAsFactors = FALSE )
class( mydat[,1] ) <- "isodatetime"                     # required
('character' is not currently accepted as isodatetime column (will be
fixed))
class( mydat[,2] ) <- "oledatetime"                     # optional
('numeric' will be accepted as oledatetime column)

  # write data (note: FALSE is necessary to keep the data.frame)
xls <- xls.new ( "testfile.xls" )                       # create
new
spreadsheet and keep in memory
write.xls( mydat[,1,FALSE], xls, sheet = 1, cols = 1 )  # write
write.xls( mydat[,2, FALSE], xls, sheet = 1, cols = 2 ) # do.
write.xls( mydat[,3, FALSE], xls, sheet = 1, cols = 3, colClasses
"oledatetime" ) # do.
write.xls( mydat[,4], xls, sheet = 2 )                  # do. in sheet 2
xls.sheet( xls, 'select', 1 )                           # first sheet
shall be active when spreadsheet is opened
xls.close( xls )                                        # save and
close memory represention

Hope this helps/clarifies things. Otherwise feel free to ask again (PM
prefered as it's probably better not to use the r-help mailling list
for questions about a non-free library). Btw, there will be a forum
some time later.

Cheers,
Hans-Peter