[R] read.xls can't read some .xls files

From: shrey sinha <shreysinha1_at_gmail.com>
Date: Mon, 14 Mar 2011 17:37:42 +0530


Hi,

I am having problem with the read.xls function. I am trying to read a .xls file but
it's giving me error.

> read.xls("XXX.xls")

Error parsing file 'XXX.xls'.
Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, :   Intermediate file '/tmp/Rtmp5QQjSI/file1665315c.csv' missing! In addition: Warning message:
running command '"/usr/bin/perl"
"/home/t227/R/x86_64-pc-linux-gnu-library/2.12/gdata/perl/xls2csv.pl" "XXX.xls" "/tmp/Rtmp5QQjSI/file1665315c.csv" "1"' had status 9 Error in file.exists(tfn) : invalid 'file' argument

And the file which I am trying to read opens perfectly in Open Office.

Any help will be appreciated.

-- 
Regards,
Shrey Sinha

	[[alternative HTML version deleted]]

______________________________________________
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.
Received on Mon 14 Mar 2011 - 12:11:50 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 15 Mar 2011 - 00:10:22 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive