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

mauede at alice.it mauede at alice.it
Tue May 25 13:12:30 CEST 2010


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


e tutti i telefonini TIM!
Vai su 


More information about the R-help mailing list