search for: oledatetim

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

...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/xlsReadWr...

...Excel files. The Pro version is a shareware package and adds features such as: ? Sheet handling (select/insert/copy/delete/ren.) ? Select regions (columns, rows, cells or area) ? Append data (several possibilities) ? Work with multiple files at the same time ? Inside information of an Excelfile ? oledatetime classes (Beta) with many additional functions ? the pro version is formally supported. Please have a look for yourself. I have put the documentation online: http://treetron.googlepages.com/00Index.html, http://treetron.googlepages.com/read.xls.html, http://treetron.googlepages.com/xls.sheet.html,...

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 --

...ve become integers o date time helper functions: - properly initialize format settings (with GetUserDefaultLangID, it probably incorrectly defaulted to US settings on some systems before) - isodatetime format: some time formats added - yesterday() and tomorrow() give back dates instead of oledatetimes o misc. other bugfixes (writing RUnit tests exposes glitches, ahem...) --- 'technical' --- o move from Subversion to git o quite substancial code refactoring Cheers, Hans-Peter