[R] read.xls (gdata) problem

Gabor Grothendieck ggrothendieck at gmail.com
Tue Sep 6 13:08:28 CEST 2011

On Tue, Sep 6, 2011 at 3:44 AM, Peter Engelbrecht <peter at engelbrecht.dk> wrote:
> 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).

That message is given when it tries to open the file and its not able
to or its not a valid spreadsheet file,

Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com

More information about the R-help mailing list