[R] how can I read a non-standard XLS file

(Ted Harding) Ted.Harding at manchester.ac.uk
Tue May 25 13:29:56 CEST 2010

On 25-May-10 11:12:30, mauede at alice.it wrote:
> I have attached a file downloaded from database mirWalk.
> Apparently it is in XLS format (this is the extension of the
> downloaded file).
> However, I cannot open it with OpenOffife spreadsheet program
> and Excel itself cannot separate the columns as it does when
> a true XLS file is loaded.
> I tried to read the attached downloaded file through R function
> "read.xls" and got the following message
>> read.xls("Prostatic_Neoplasm-miRNAs.Disease-GenesTargets.xls")
> Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, 
>   Unable to read translated csv file
> '/tmp/RtmpPIe3vo/file15d9580e.csv'.
> Error in file.exists(tfn) : invalid 'file' argument
> I have tried reading the file through "read.table" which has
> now been hanging for  more than 15 minutes.
> Please, advice.
> Thank you in advance.
> Maura

Maura, your attachment did not reach the list (with a few exceptions,
such as PDF, attachments are generally discarded).

Can you post a URL from which that file can be downloaded, so that
we can try for ourselves?


E-Mail: (Ted Harding) <Ted.Harding at manchester.ac.uk>
Fax-to-email: +44 (0)870 094 0861
Date: 25-May-10                                       Time: 12:29:35
------------------------------ XFMail ------------------------------

More information about the R-help mailing list