search for: datetimea

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 colClasses="character". But this overrules the isodatetime. Now is there someway I can read i...

Hello, I have got the following problem: > setwd("C:/temp") > library(xlsReadWrite) > MyData <- read.xls(file="Mappe1.xls", colNames = TRUE,dateTimeAs = "isodatetime") > attach(MyData) > MyData name value times 1 A1 2 2006-05-12 2 A2 3 2006-05-16 3 A3 1 2006-05-12 4 A4 4 2006-05-12 5 A5 2 2006-05-16 6 A6 1 2006-05-12 > plot(times,value) Error........ Could you help me please...

...r. - "xls.range" to retrieve information about named ranges. (motivated by Michael Clifford) - "xls.images" to add an image into an Excel spreadsheet (motivated by Mark W. Kimpel and Michael Clifford) - "useOleDateTime" has been changed to "dateTimeAs". This argument is used to decide how Excel date and time values should be handled if no explicit "colClasses" argument has been given. Possible values are: - "numeric" (numeric value) - "oledatetime" (numeric value of class oleDate, oleTime o...

...ds this) - some other small fixes o Function declarations as per v1.3.2 - read.xls( file, colNames = TRUE, sheet = 1, type = "data.frame", from = 1, rowNames = NA, colClasses = NA, checkNames = TRUE, dateTimeAs = "numeric", stringsAsFactors = default.stringsAsFactors() ) - write.xls( x, file, colNames = TRUE, sheet = 1, from = 1, rowNames = NA ) - dateTimeToStr( odate, format = "" ) - strToDateTime( sdat...

...: "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/form...

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

Hi, i'm trying to read some data from excel files but it seems that neither xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0). When i open the file in Excel and save it in a new format Excel 97 -2003 everything works fine. Is it possible to use ODBC connection to open old format files, or i guess i will have to open and save every file in Excel in new format, which

...e possibility to free 'my' pointer. Not good). Thanks to the (anonymous) user which submitted the nice bug report! - NaN values will be written as 'NaN' and behaviour (e.g. coercion) better accounts R (see read.xls.Rd, write.xls.Rd and unitTests/runitNaNaN.R). - 'dateTimeAs' argument in read.xls has been renamed to 'dateTime'. When using the default (which should be fine in most cases) this change won't affect you. - fix startup message scrambling in R2.12.0 (LF instead of CRLF - reported to Rdevel) - simplified file (unitTests/execManually.R)...