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, <[email protected]> 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 [[email protected]] > Sent: 14 July 2012 20:04 > To: Rodriguez Fernandez, Ricardo Julio > Cc: [email protected] > 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, <[email protected]> > 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 [[email protected]] >> Sent: 14 July 2012 19:21 >> To: Rodriguez Fernandez, Ricardo Julio >> Cc: [email protected] >> 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, <[email protected]> >> 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 >>> [email protected] >>> 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 > [email protected] > https://stat.ethz.ch/mailman/listinfo/r-sig-mac _______________________________________________ R-SIG-Mac mailing list [email protected] https://stat.ethz.ch/mailman/listinfo/r-sig-mac
