search for: datetimetostr

...type can be automatically determined from the value(s) of the first Excel row (determined from the cell formatting as there 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 "stringsA...

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

I have used xlsReadWrite to read data from an Excel spreadsheet. I had a problem with converting times of the day so that I could create POSIXct date-time objects. I was wondering if there was a better solution. Excel stores times of the day as fractions of a day so I wrote a function to convert the fraction to a number of seconds, extract the hours, minutes and seconds and output it in ISO

...= NA, rows = NA, 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,...

R I am taking an excel dataset and reading it into R using read.table. (actually I am dumping the data into a .txt file first and then reading data in to R). Here is snippet: > head(data); Date Price Open.Int. Comm.Long Comm.Short net.comm 1 15-Jan-86 673.25 175645 65910 28425 37485 2 31-Jan-86 677.00 167350 54060 27120 26940 3 14-Feb-86 680.25