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.fell...@stat.ucla.edu]
Sent: 14 July 2012 19:21
To: Rodriguez Fernandez, Ricardo Julio
Cc: r-sig-mac@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.fernan...@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@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
_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
