> I was using older version of R (installed early). I install new version of R
> (R.2.9.0) but i could not find package "xlsReadWrite" to read Excel file.
As others have pointed out (thanks) you can find it here:
http://treetron.googlepages.com/.
It runs fine in 2.9.0.
> Is there any alternative
Check out:
http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows
On 6/15/09, ram basnet wrote:
> Dear all,
>
> I was using older version of R (installed early). I install new version of R
> (R.2.9.0) but i could not find package "xlsReadWrite" to read Excel file. Is
> there any alte
Talita Perciano wrote:
Hi,
The xlsReadWrite package is at the R site in the archive packages in
CRAN (http://cran-r.c3sl.ufpr.br/src/contrib/Archive/xlsReadWrite/). You
should also take a look at the package RExcelInstaller.
Talita
I am not sure if there are any updates of the package since i
Hi,
The xlsReadWrite package is at the R site in the archive packages in
CRAN (http://cran-r.c3sl.ufpr.br/src/contrib/Archive/xlsReadWrite/). You
should also take a look at the package RExcelInstaller.
Talita
Em Seg, 2009-06-15 às 15:28 -0700, ram basnet escreveu:
> Dear all,
>
> I was using ol
yet another possibility...
if you look at 'help(package=xlsReadWrite)' you'll find a function
'dateTimeToStr' by which you can convert your date-numbers from column 3
into a string. Something along (untested):
myRead <- function( fn ) {
dat <- read.xls( file = fn, dateTimeAs = "numeric" )
dat
essage-
> From: Gabor Grothendieck [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 25, 2008 8:43 PM
> To: Utkarsh Singhal
> Cc: [EMAIL PROTECTED]
> Subject: Re: [R] reading Excel file
>
>
>
> If d is the number of days since the Epoch then
>
>
>
> now <
PROTECTED]
Subject: Re: [R] reading Excel file
If d is the number of days since the Epoch then
now <- Sys.Date()
now - julian(now) + d
will give you a "Date" class variable. There is some info on dates in
R News 4/1.
On Tue, Mar 25, 2008 at 10:00 AM, Utkarsh Singhal
<
Even if you don't know the number of columns, you probably know the name
of the date variables. You can read the Excel file "as is" and later
convert dates in R:
Reading the date from Excel gives the daynumber. There is the difference
between day zero for R (1. 1. 1970) and Excel (31. 12. 1899) an
why can't you know the number of columns if it is an excel file?
On Tue, Mar 25, 2008 at 2:36 PM, Earl F. Glynn
<[EMAIL PROTECTED]> wrote:
> "Utkarsh Singhal" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
> > Hi R,
>
> > I have an excel file in which the third column is "date"
"Utkarsh Singhal" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi R,
> I have an excel file in which the third column is "date" and others are
> "character" and "numeric".
>
> If I use this to read the file in R: x = read.xls("D:\\file.xls")
>
> The problem is that my date colu
You can convert the days to Date class after reading it in.
See R News 4/1.
On Tue, Mar 25, 2008 at 10:00 AM, Utkarsh Singhal
<[EMAIL PROTECTED]> wrote:
> Hi R,
>
>
>
> I have an excel file in which the third column is "date" and others are
> "character" and "numeric".
>
> Number of columns are 12
>
> But what can I do in case I don't know the number of columns in my
> file??
>
I mean is there any way I can specify the colClass of only third column
> and for other columns it can take the default classes??
Not supported, sorry (I put it on the list).
x = read.xls( "D:\\file.xls", colClass
12 matches
Mail list logo
