[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