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

[(Ted Harding)]

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?

Thanks,
Ted.


--------------------------------------------------------------------
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 ------------------------------