On Tue, Sep 6, 2011 at 3:44 AM, Peter Engelbrecht <pe...@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 ______________________________________________ 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.
