Import excel file

Hello,

I believe it is, but see package XLConnect. The vignette is very 
helpfull, with lots of examples.

Hope this helps,

Rui Barradas
Em 16-11-2012 15:27, Hervy Cyril escreveu:

Hello,

Is it possible to import an Excel 2000 file (32-bit version) into R 2.15.1 64-bit version?

Thanks.
Best regards,

Cyril Hervy

	[[alternative HTML version deleted]]

______________________________________________
R-help at 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.

Hello,

I believe it is, but see package XLConnect. The vignette is very
helpfull, with lots of examples.

... and many other ways. Please see the manual "R Data Import/Excel" 
that ships with R and has a whole section devoted to Excel.

Best,
Uwe Ligges

Hope this helps,

Rui Barradas
Em 16-11-2012 15:27, Hervy Cyril escreveu:

Hello,

Is it possible to import an Excel 2000 file (32-bit version) into R
2.15.1 64-bit version?

Thanks.
Best regards,

Cyril Hervy

    [[alternative HTML version deleted]]

______________________________________________
R-help at 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 at 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.

Hello,

According to manual ""R Data Import/Excel", xlsreadWrite package  and RODBC package  are used for 32-bit version (tests confirmed this observation)
I used XLConnect package but it returned this error :
"Erreur dans new(J("com.miraisolutions.xlconnect.integration.r.RWorkbookWrapper"),  : 
  erreur d'?valuation de l'argument 'Class' lors de la s?lection d'une m?thode pour la fonction 'new' : Erreur dans .jfindClass(as.character(class)) : class not found"

Thanks for your help

Best regards,

Cyril Hervy


-----Message d'origine-----
De : Uwe Ligges [mailto:ligges at statistik.tu-dortmund.de] 
Envoy? : dimanche 18 novembre 2012 19:10
? : Rui Barradas
Cc : Hervy Cyril; r-help at r-project.org
Objet : Re: [R] Import excel file

Hello,

I believe it is, but see package XLConnect. The vignette is very 
helpfull, with lots of examples.

... and many other ways. Please see the manual "R Data Import/Excel" 
that ships with R and has a whole section devoted to Excel.

Best,
Uwe Ligges

Hope this helps,

Rui Barradas
Em 16-11-2012 15:27, Hervy Cyril escreveu:

Hello,

Is it possible to import an Excel 2000 file (32-bit version) into R
2.15.1 64-bit version?

Thanks.
Best regards,

Cyril Hervy

    [[alternative HTML version deleted]]

______________________________________________
R-help at 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 at 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.

Hi Cyril,

please let me know the following details:
- sessionInfo() output from R
- Version of XLConnect you are using
- Version of rJava you are using
- Version of Java you are using (complete output of "java -version" on the
command line)
- Value of the JAVA_HOME environment variable if it is set (e.g. output of
Sys.getenv("JAVA_HOME") in R)

Best regards,
Martin



--
View this message in context: http://r.789695.n4.nabble.com/Import-excel-file-tp4649755p4650087.html
Sent from the R help mailing list archive at Nabble.com.