[R] gdata

[Gabor Grothendieck]

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 <moni at 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 at 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.
>