How to Import Excel file into R 2.9.0 version

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

How to Import Excel file into R 2.9.0 version

rajclinasia
Hi Every one,
I have a problem with Reading Excel file into R 2.9.0 version. In older versions it is working with "xlsReadWrite" package. But in 2.9.0 version there is no package like that. so help me out in this aspect.

Thanks in Advance.
Reply | Threaded
Open this post in threaded view
|

Re: How to Import Excel file into R 2.9.0 version

Wincent
You can download it from http://treetron.googlepages.com/xlsreadwrite.htm

Also, you may have a look at Data import/export manual, which has a
relevant section.

Ronggui

2009/8/11 rajclinasia <[hidden email]>:

>
> Hi Every one,
> I have a problem with Reading Excel file into R 2.9.0 version. In older
> versions it is working with "xlsReadWrite" package. But in 2.9.0 version
> there is no package like that. so help me out in this aspect.
>
> Thanks in Advance.
> --
> View this message in context: http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> [hidden email] 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.
>



--
HUANG Ronggui, Wincent
PhD Candidate
Dept of Public and Social Administration
City University of Hong Kong
Home page: http://asrr.r-forge.r-project.org/rghuang.html

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: How to Import Excel file into R 2.9.0 version

Rodrigo Aluizio
In reply to this post by rajclinasia
Hi, take a look at the gdata package (any plataform) function read.xls(),
and at the package RODBC (if you are on a Windows Plataform) at the
functions odbcConnectExcel(), odbcConnectExcel2007() and sqlFetch().

Hope this helps

Rodrigo.

2009/8/11 rajclinasia <[hidden email]>

>
> Hi Every one,
> I have a problem with Reading Excel file into R 2.9.0 version. In older
> versions it is working with "xlsReadWrite" package. But in 2.9.0 version
> there is no package like that. so help me out in this aspect.
>
> Thanks in Advance.
> --
> View this message in context:
> http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> [hidden email] 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.
>

        [[alternative HTML version deleted]]

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re : How to Import Excel file into R 2.9.0 version

Inchallah Yarab


i advice you to save the file under csv and then use
read.csv2("c:/file.csv",sep=",")
hope that helps!!!

inchallahyarab

2009/8/11 rajclinasia <[hidden email]>

>
> Hi Every one,
> I have a problem with Reading Excel file into R 2.9.0 version. In older
> versions it is working with "xlsReadWrite" package. But in 2.9.0 version
> there is no package like that. so help me out in this aspect.
>
> Thanks in Advance.
> --
> View this message in context:
> http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> [hidden email] 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.
>
    [[alternative HTML version deleted]]

______________________________________________
[hidden email] 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.



     
        [[alternative HTML version deleted]]


______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

RES: Re : How to Import Excel file into R 2.9.0 version

Leandro Marino
Another possibility is to download the xlsReadWrite package in http://treetron.googlepages.com/xlsreadwrite.htm

And use the read.xls() function.

I am using this package without problems.



Atenciosamente,
Leandro Lins Marino
Centro de Avaliação
Fundação CESGRANRIO
Rua Santa Alexandrina, 1011 - 2º andar
Rio de Janeiro, RJ - CEP: 20261-903
R (21) 2103-9600 R.:236
  (21) 8777-7907
( [hidden email]

"Aquele que suporta o peso da sociedade
    é precisamente aquele que obtém
 as menores vantagens". (SMITH, Adam)

  Antes de imprimir pense em sua responsabilidade e compromisso com o MEIO AMBIENTE

Esta mensagem, incluindo seus anexos, pode conter informacoes privilegiadas e/ou de carater confidencial, nao podendo ser retransmitida sem autorizacao do remetente. Se voce nao e o destinatario ou pessoa autorizada a recebe-la, informamos que o seu uso, divulgacao, copia ou arquivamento sao proibidos.
Portanto, se você recebeu esta mensagem por engano, por favor, nos informe respondendo imediatamente a este e-mail e em seguida apague-a.


-----Mensagem original-----
De: [hidden email] [mailto:[hidden email]] Em nome de Inchallah Yarab
Enviada em: terça-feira, 11 de agosto de 2009 09:33
Para: [hidden email]
Assunto: [R] Re : How to Import Excel file into R 2.9.0 version



i advice you to save the file under csv and then use
read.csv2("c:/file.csv",sep=",")
hope that helps!!!

inchallahyarab

2009/8/11 rajclinasia <[hidden email]>

>
> Hi Every one,
> I have a problem with Reading Excel file into R 2.9.0 version. In
> older versions it is working with "xlsReadWrite" package. But in 2.9.0
> version there is no package like that. so help me out in this aspect.
>
> Thanks in Advance.
> --
> View this message in context:
> http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp
> 24914638p24914638.html Sent from the R help mailing list archive at
> Nabble.com.
>
> ______________________________________________
> [hidden email] 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.
>

    [[alternative HTML version deleted]]

______________________________________________
[hidden email] 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.



     
        [[alternative HTML version deleted]]

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: How to Import Excel file into R 2.9.0 version

Lamke
In reply to this post by rajclinasia
Use odbcConnectExcel() in the RODBC package.  

rajclinasia wrote
Hi Every one,
I have a problem with Reading Excel file into R 2.9.0 version. In older versions it is working with "xlsReadWrite" package. But in 2.9.0 version there is no package like that. so help me out in this aspect.

Thanks in Advance.
Reply | Threaded
Open this post in threaded view
|

Re: Re : How to Import Excel file into R 2.9.0 version

Moshe Olshansky-2
In reply to this post by Inchallah Yarab
Alternatively download the xlsReadWrite package from http://treetron.googlepages.com/ 
install it an proceed as in older version of R.

--- On Tue, 11/8/09, Inchallah Yarab <[hidden email]> wrote:

> From: Inchallah Yarab <[hidden email]>
> Subject: [R] Re :  How to Import Excel file into R 2.9.0 version
> To: [hidden email]
> Received: Tuesday, 11 August, 2009, 10:32 PM
>
>
> i advice you to save the file under csv and then use
> read.csv2("c:/file.csv",sep=",")
> hope that helps!!!
>
> inchallahyarab
>
> 2009/8/11 rajclinasia <[hidden email]>
>
> >
> > Hi Every one,
> > I have a problem with Reading Excel file into R 2.9.0
> version. In older
> > versions it is working with "xlsReadWrite" package.
> But in 2.9.0 version
> > there is no package like that. so help me out in this
> aspect.
> >
> > Thanks in Advance.
> > --
> > View this message in context:
> > http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html
> > Sent from the R help mailing list archive at
> Nabble.com.
> >
> > ______________________________________________
> > [hidden email]
> 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.
> >
>
>     [[alternative HTML version deleted]]
>
> ______________________________________________
> [hidden email]
> 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.
>
>
>
>      
>     [[alternative HTML version deleted]]
>
>
> -----Inline Attachment Follows-----
>
> ______________________________________________
> [hidden email]
> 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.
>

______________________________________________
[hidden email] 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.