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