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
It appears you are using read.xls in gdata. In that case be sure you are using the latest version of gdata on CRAN since there was a problem with one older version. There is more info on read.xls in gdata here and also listed there are alternatives you can try: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel On Tue, May 25, 2010 at 7:12 AM, <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 > > > e tutti i telefonini TIM! > Vai su > > ______________________________________________ > 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. > >
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. > MauraMaura, 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 ------------------------------