installXLSXsupport() error
You didn't have to go through the command line. In the R GUI's package installer, if you switched package repository to "CRAN (sources)", you would have found XLConnect there too. You don't mention the version of OS X you're running, but for me with Lion and R 2.15.1, I have the same problem. Most binary packages on CRAN will not be found, and so I always choose to install from source. Davor
On 2012-07-14, at 11:30 AM, <Ricardo.Julio.Rodriguez.Fernandez at sergas.es> wrote:
Thanks, Ian, I looked for XLConnect with the package installer in CRAN binaries (R 2.15.1 GUI 1.52) and found nothing. Here what I get from the R prompt...
install.packages("XLConnect")
Installing package(s) into ?/Users/rrodriguez/Library/R/2.15/library? (as ?lib? is unspecified) Warning message: package ?XLConnect? is not available (for R version 2.15.1)
I've installed it from CRAN sources and all seems to work fine now! Thanks for your help! Once again, I'm impressed and happy to keep trying to understand this great environment and, perhaps some day, contribute to the community. Cheers, Ricardo
________________________________________
From: Ian Fellows [ian.fellows at stat.ucla.edu]
Sent: 14 July 2012 20:04
To: Rodriguez Fernandez, Ricardo Julio
Cc: r-sig-mac at r-project.org
Subject: Re: [R-SIG-Mac] installXLSXsupport() error
You only loaded the JAR package, not the actual XLConnect package.
install.packages("XLConnect")
library(XLConnect)
On Jul 14, 2012, at 10:59 AM, <Ricardo.Julio.Rodriguez.Fernandez at sergas.es> wrote:
Thanks, Ian! It seems like an impressive improvement providing a comprehensive set of functions to interact with XLSX spreadsheets!
But I'm afraid I'm missing something. Please, check this...
*****
sessionInfo()
R version 2.15.1 (2012-06-22)
Platform: x86_64-apple-darwin9.8.0/x86_64 (64-bit)
locale:
[1] en_GB.UTF-8/en_GB.UTF-8/en_GB.UTF-8/C/en_GB.UTF-8/en_GB.UTF-8
attached base packages:
[1] graphics grDevices utils datasets stats methods base
other attached packages:
[1] XLConnectJars_0.1-4 rJava_0.9-3 foreign_0.8-50
loaded via a namespace (and not attached):
[1] tools_2.15.1
wb <- loadWorkbook("XLConnect.xlsx", create = TRUE)
Error: could not find function "loadWorkbook"
*****
Please, do you know why am I not able to use loadWorkbook function? Other functions like existsSheet() or extractSheetName(). Always same error: Error: could not find function "concerned function".
Thanks for your help!
Ricardo
________________________________________
From: Ian Fellows [ian.fellows at stat.ucla.edu]
Sent: 14 July 2012 19:21
To: Rodriguez Fernandez, Ricardo Julio
Cc: r-sig-mac at r-project.org
Subject: Re: [R-SIG-Mac] installXLSXsupport() error
much better support for Excel is available via the XLConnect and xlsx packages. I would recommend that you give them a try.
ian
On Jul 14, 2012, at 9:15 AM, <Ricardo.Julio.Rodriguez.Fernandez at sergas.es> wrote:
Hi!
Until now I've survive exporting my spreadsheets to CSV files, but this process is a error-prone as it is by no means easy to keep track of updated releases. Some weeks ago a new thread here talked about reading XLSX files by using gdata(): it would be really great to be able to get this working here, but I'm running into some trouble. Gdata works fine to read XLS format, but I'm not able to get XLSX support. Please, check this outputs. First of all: sessionInfo()...
*****
sessionInfo()
R version 2.15.1 (2012-06-22)
Platform: x86_64-apple-darwin9.8.0/x86_64 (64-bit)
locale:
[1] en_GB.UTF-8/en_GB.UTF-8/en_GB.UTF-8/C/en_GB.UTF-8/en_GB.UTF-8
attached base packages:
[1] graphics grDevices utils datasets stats methods base
other attached packages:
[1] gdata_2.11.0 foreign_0.8-50
loaded via a namespace (and not attached):
[1] gtools_2.7.0
library(gdata)
gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED.
gdata: Unable to load perl libaries needed by read.xls()
gdata: to support 'XLSX' (Excel 2007+) files.
gdata: Run the function 'installXLSXsupport()'
gdata: to automatically download and install the perl
gdata: libaries needed to support Excel XLS and XLSX formats.
Attaching package: ?gdata?
The following object(s) are masked from ?package:utils?:
object.size
The following object(s) are masked from ?package:stats?:
nobs
xlsFormats()
[1] "XLS"
installXLSXsupport(verbose=TRUE)
Using perl at /usr/bin/perl
Attempting to automaticall install Perl libraries to support XLSX (Excel 2007+) file format...
Results:
Using perl at /usr/bin/perl
Determining supported formats...
Results: Supported formats: XLS
Error in installXLSXsupport(verbose = TRUE) :
Unable to install Perl XLSX support libraries.
In addition: Warning message:
running command ''/usr/bin/perl' '/Library/Frameworks/R.framework/Versions/2.15/Resources/library/gdata/perl/install_modules.pl'' had status 22
Can't locate object method "load" via package "CPAN::HandleConfig" (perhaps you forgot to load "CPAN::HandleConfig"?) at /Library/Frameworks/R.framework/Versions/2.15/Resources/library/gdata/perl/module_tools.pl line 89.
Error in installXLSXsupport(verbose = TRUE) :
Unable to install Perl XLSX support libraries.
In addition: Warning message:
running command ''/usr/bin/perl' '/Library/Frameworks/R.framework/Versions/2.15/Resources/library/gdata/perl/install_modules.pl'' had status 22
Can't locate object method "load" via package "CPAN::HandleConfig" (perhaps you forgot to load "CPAN::HandleConfig"?) at /Library/Frameworks/R.framework/Versions/2.15/Resources/library/gdata/perl/module_tools.pl line 89.
*****
I've read ?installXLSXsupport and I think I've correctly installed Compress::Raw::Zlib and Spreadsheet::XLSX from terminal (by using sudo perl -MCPAN -e 'install Bundle::Name'). I've even tried with a different Perl flavour, ActivePerl, but got a different set of errors. I'm afraid I'll make my installation an awfull mess if I keep trying to get an answer on my own! Please, could you help me? Do you know where am I wrong? How could I get XLSX support working in my MacBook Pro running Mac OS X 10.5.8?
Thank you so much for your help,
Ricardo
--
Ricardo Rodr?guez
Research Management and Promotion Technician
Technical Secretariat
Health Research Institute of Santiago de Compostela (IDIS)
http://www.idisantiago.es
Nota: A informaci?n contida nesta mensaxe e os seus posibles documentos adxuntos ? privada e confidencial e est? dirixida ?nicamente ? seu destinatario/a. Se vostede non ? o/a destinatario/a orixinal desta mensaxe, por favor elim?nea. A distribuci?n ou copia desta mensaxe non est? autorizada.
Nota: La informaci?n contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y est? dirigida ?nicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elim?nelo. La distribuci?n o copia de este mensaje no est? autorizada.
See more languages: http://www.sergas.es/aviso_confidencialidad.htm
_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac at r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
Nota: A informaci?n contida nesta mensaxe e os seus posibles documentos adxuntos ? privada e confidencial e est? dirixida ?nicamente ? seu destinatario/a. Se vostede non ? o/a destinatario/a orixinal desta mensaxe, por favor elim?nea. A distribuci?n ou copia desta mensaxe non est? autorizada.
Nota: La informaci?n contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y est? dirigida ?nicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elim?nelo. La distribuci?n o copia de este mensaje no est? autorizada.
See more languages: http://www.sergas.es/aviso_confidencialidad.htm
Nota: A informaci?n contida nesta mensaxe e os seus posibles documentos adxuntos ? privada e confidencial e est? dirixida ?nicamente ? seu destinatario/a. Se vostede non ? o/a destinatario/a orixinal desta mensaxe, por favor elim?nea. A distribuci?n ou copia desta mensaxe non est? autorizada.
Nota: La informaci?n contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y est? dirigida ?nicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elim?nelo. La distribuci?n o copia de este mensaje no est? autorizada.
See more languages: http://www.sergas.es/aviso_confidencialidad.htm
_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac at r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-mac