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
_______________________________________________
R-SIG-Mac mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
