Displaying 3 results from an estimated 3 matches for "datetimetoisostr".
2007 Apr 27
0
Update of xlsReadWrite package
...here 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*....
2007 Oct 09
1
Read in date fomat while colClasses="character"
Hi R users,
I am using xlsReadWrite to read a particular excel file. In one of the
columns I have dates ( say col=5). Now date column is read by default as
numeric. So I used dateTimeAs= "isodatetime". This enables reading in
the date format. However in the earlier column (say col=1) I have data
which however starts from row 10. So to read data from column one I use
2007 Apr 27
0
[ANN:] new package xlsReadWrite*Pro*: announce + update.
..., cols = NA, cells = NA,
rowNames = NA, colClasses = NA,
dateTimeAs = "oledatetime",
keep = NA,
append = FALSE )
- xls.info, xls.sheet, xls.range, xls.image, xls.new, xls.open,
xls.save, xls.cancel, xls.close
- languagesAndLCID, dateTimeToStr, dateTimeToIsoStr, strToDate,
strToDateTime, strToTime, isoStrToDateTime, shortDateFormat,
longTimeFormat, encodeDateTime, encodeDate, encodeTime, decodeDateTime
- dateOf, timeOf, isInLeapYear, isPM, weeksInYear, daysInYear,
daysInMonth, now, today, isToday, yesterday, tomorrow, yearOf,
monthOf, weekOf, dayOf, ho...