Re: [R] Import excel file
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:lig...@statistik.tu-dortmund.de] Envoyé : dimanche 18 novembre 2012 19:10 À : Rui Barradas Cc : Hervy Cyril; r-help@r-project.org Objet : Re: [R] Import excel file On 16.11.2012 16:59, Rui Barradas wrote: 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@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@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@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.
Re: [R] Import excel file
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. __ R-help@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.
Re: [R] Import excel file
On 16.11.2012 16:59, Rui Barradas wrote: 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@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@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@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] Import excel file
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@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.
Re: [R] 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@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@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.
