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
