search for: oledate

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(xls...

...ing capabilities have been added (compared to xlsReadWrite): ? in-memory objects (compose reports, append) ? better sheet handling (select/ins/copy/del/...) ? data area subsets (rows/cols/from/to/area) ? use (named) ranges and pick individual cells ? insert images, hyperlinks, work with formulas ? oledatetime type and many helper functions ? get information about an Excelfile. Browse the (shortened) help files: http://treetron.googlepages.com/00Index.html Download a brochure: http://treetron.googlepages.com/xlsReadWrite_Pro_Datasheet.pdf Download the package: http://treetron.googlepages.com/xlsRea...

Dear all, I often use dates and times in analyses. I just can't figure out how to format my date or time column in R. So, apparently R sees the date as something other than date (character). Let's say I am opening a CSV file, one of the columns of which is a date or time. How do I specify that when opening the file? Thanks for the help, Jim --