I have had problems with gdata 2.7.1 on Windows but have been successfully using the development version of gdata with ActivePerl likely the same applies to Mac. The development version of gdata is in the svn repository here:
https://r-gregmisc.svn.sourceforge.net/svnroot/r-gregmisc/trunk/gdata Alternately, if you do not need the newer features (xlsx files, sheetNames function, ability to specify which sheet by name and not just by number) see if you can find the older gdata 2.6.1 on the net. > library(gdata) # development version > > # get path and name of Excel 2007 example file in gdata > xlsx <- file.path(.path.package('gdata'),'xls', 'ExampleExcelFile.xlsx') > > read.xls(xlsx, nrows = 3) A B C 1 1 1 1 2 2 4 8 3 3 9 27 > > sheetNames(xlsx) [1] "Sheet First" "Sheet Second" [3] "Sheet with a very long name!" "Sheet with initial text" > R.version.string # Vista [1] "R version 2.10.1 Patched (2010-01-22 r51019)" On Wed, Feb 24, 2010 at 5:28 AM, blazejneradilek <m...@mwlight.com> wrote: > > Have a similar problem. > > Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : > Unable to read translated csv file > '/var/folders/na/na-E2tFsFOCIoeD-x5EV6k+++TI/-Tmp-//RtmpS393Mj/file10d63af1.csv'. > Error in file.exists(tfn) : invalid 'file' argument > Can't load > '/Library/Frameworks/R.framework/Resources/library/gdata/perl/darwin-thread-multi-2level/auto/Compress/Raw/Zlib/Zlib.bundle' > for module Compress::Raw::Zlib: > /Library/Frameworks/R.framework/Resources/library/gdata/perl/darwin-thread-multi-2level/auto/Compress/Raw/Zlib/Zlib.bundle: > no appropriate 64-bit architecture (see "man perl" for running in 32-bit > mode) at > /System/Library/Perl/5.10.0/darwin-thread-multi-2level/DynaLoader.pm line > 207. > at > /Library/Frameworks/R.framework/Resources/library/gdata/perl/Archive/Zip.pm > line 12 > Compilation failed in require at > /Library/Frameworks/R.framework/Resources/library/gdata/perl/Archive/Zip.pm > line 12. > BEGIN failed--compilation aborted at > /Library/Frameworks/R.framework/Resources/library/gdata/perl/Archive/Zip.pm > line 12. > Compilation failed in require at > /Library/Frameworks/R.framework/Resources/library/gdata/perl/Spreadsheet/XLSX.pm > line 11. > BEGIN failed--compilation aborted at > /Library/Frameworks/R.framework/Resources/library/gdata/perl/Spreadsheet/XLSX.pm > line 11. > Compilation failed in require at > /Library/Frameworks/R.framework/Resources/library/gdata/perl/xls2csv.pl line > 11. > BEGIN failed--compilation aborted at > /Library/Frameworks/R.framework/Resources/library/gdata/perl/xls2csv.pl line > 11. > > Tried installing Active Perl - still the same problem > Tried the archive version 2.7.0 package and got this error message: > >> install.packages("gdata_2.7.0.tar.gz") > Warning message: > In getDependencies(pkgs, dependencies, available, lib) : > package ‘gdata_2.7.0.tar.gz’ is not available > -- > View this message in context: > http://n4.nabble.com/gdata-tp1477079p1567270.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
