[R] read.xls (gdata) problem

Peter Engelbrecht peter at engelbrecht.dk
Tue Sep 6 09:44:10 CEST 2011


I've suddenly started seeing a consistent problem with read.xls.

No matter what xls file I try I always get an error message of this type:

Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method,  : 
  Intermediate file
'/var/folders/cb/vvshkpm90lx_y2n69qlyw4z40000gn/T//RtmpK50r4g/file546a2722.csv'
missing!
In addition: Warning message:
running command '"/usr/bin/perl"
"/Library/Frameworks/R.framework/Versions/2.13/Resources/library/gdata/perl/xls2csv.pl"
"/Users/peter/dev/R/telenor pricelists/ild_price_processor/ILD priser
2011.10.01.xls"
"/var/folders/cb/vvshkpm90lx_y2n69qlyw4z40000gn/T//RtmpK50r4g/file546a2722.csv"
"1"' had status 255 
Error in file.exists(tfn) : invalid 'file' argument
Error parsing file '/Users/peter/dev/R/telenor
pricelists/ild_price_processor/ILD priser 2011.10.01.xls'.

E.g. using this code:
> fn = file.choose()
> read.xls(fn)
With many different .xls files, including ones I have read with read.xls in
the past.

When I try running the xls2csv perl script (which read.xls depends on)
directly from the command line I get the following error message:

$ perl xls2csv.pl ~/Downloads/900numre.xls ~/Downloads/900numre.csv 1 
Loading '/Users/peter/Downloads/900numre.xls'...
Error parsing file '/Users/peter/Downloads/900numre.xls'.

So it's pretty obvious the perl script part has broken down. The frustrating
things is that this worked perfectly fine until today, so I (or my system)
has clearly unknowingly changed some part of the configuration (I'm on OS
X).

Any ideas?

Rgds,
Peter

--
View this message in context: http://r.789695.n4.nabble.com/read-xls-gdata-problem-tp3792792p3792792.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list