> 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
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 alternatives to read Excel file ?
I hope it should be.
I need help although it is minor querry.
Thanks in advance.
Sinc
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
<
> From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
> On Behalf Of Utkarsh Singhal
> Sent: Tuesday, March 25, 2008 3:00 PM
> To: [EMAIL PROTECTED]
> Subject: [R] reading Excel file
>
> Hi R,
>
>
>
> I have an excel file in which the third column
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
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
If I use this to read the file in R: x = read.xls("D:\\file.xls")
The problem is that my date column is read in julian dates.
So I am using:
14 matches
Mail list logo