[R] reading dates in Excel into R

[Gabor Grothendieck]

On Fri, Jul 30, 2010 at 1:17 PM, Hongying Li <colorleaf at hotmail.com> wrote:
>
>  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/yyyy 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
>

You could try the various alternatives in the list on this page:

   http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel

and see if any of them work in the way you wish.