search for: datetimeas

Displaying 8 results from an estimated 8 matches for "datetimeas".

Did you mean: datetime
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 colClasses="character". But this overrules the isodatetime. Now is there someway I can read in...
2007 Sep 26
2
date
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?...
2007 Apr 27
0
[ANN:] new package xlsReadWrite*Pro*: announce + update.
...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 or...
2007 Apr 27
0
Update of xlsReadWrite package
...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( sdate...
2009 Jul 02
1
help exporting to excel via xlsReadWritePro
...: "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/formu...
2009 Feb 23
3
Dates and times from Excel
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
2009 Apr 07
4
Re ading Excel 5.0 files with RODBC?
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
2010 Nov 29
0
Updates for xlsReadWrite (1.5.3) and xlsReadWritePro (1.6.1/3)
...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)...