I just do not want the dates format change randomly (seems to me) each time I
read it from excel2007 file into R.
When I export the excel2007 fiel into csv file and use read.csv function then
the dates all come out good (as mm/dd/ in csv file).
I guess I have to first import into csv file before reading into R. Just avoid
reading from Excel2007 files directly.
Thanks,
Hongying
Date: Fri, 30 Jul 2010 10:24:50 +0100
Subject: Re: [R] reading dates in Excel into R
From: fra...@gmail.com
To: peter.alsp...@plantandfood.co.nz
CC: colorl...@hotmail.com; r-help@r-project.org
To read the data into R
1) I format my dates as -MM-DD in Excel (or OpenOffice Calc),
2) (change =na() to NA)
3) Check that required number of significant decimal places are displayed,
4) export as csv and
5) Use readSeries() function from Rmetrics timeSeries package to read
the data into R.
For what it is worth I have found this approach flexible .
Best Regards
John
On 29 July 2010 22:18, Peter Alspach peter.alsp...@plantandfood.co.nz wrote:
Tena koe
What do you want to control? You can govern the format used in R using the
appropriate R functions. I doubt it would be useful to have dates read
from Excel depend on the format set for displaying those dates in Excel.
HTH
,,,
Peter Alspach
-Original Message-
From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-
project.org] On Behalf Of Hongying Li
Sent: Friday, 30 July 2010 5:33 a.m.
To: r-help@r-project.org
Subject: [R] reading dates in Excel into R
I am reading dates in Excel2007 into R.
Here are the functions I used:
library(RODBC)
channel-odbcConnectExcel2007(myfile.xlsx)
tmp-sqlFetch(channel,1,as.is=T)
The dates in myfile.xlsx are all in this format: mm/dd/. But when I
read it to R, some columns look like -mm-dd 00:00:00, some
columns look like -mm-dd, and some columns are numbers. I do not
know how I can control this.
Any help? Thanks!
_
Hotmail is redefining busy with tools for the New Busy. Get more from
your inbox.
N:WL:en-US:WM_HMP:042010_2
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-
guide.html
and provide commented, minimal, self-contained, reproducible code.
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
--
John C Frain
Economics Department
Trinity College Dublin
Dublin 2
Ireland
www.tcd.ie/Economics/staff/frainj/home.html
mailto:fra...@tcd.ie
mailto:fra...@gmail.com
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.