Im 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]]
______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.