Through clicking on the xls file oocalc (OpenOffice spreadsheet module) is automatically launched. But in my case it cannot load it correctly regardless of my choices (separator, etc..). Maybe I should switch to another Linux distribution. Thank you very much. Maura
-----Messaggio originale----- Da: ted.hard...@manchester.ac.uk [mailto:ted.hard...@manchester.ac.uk] Inviato: mar 25/05/2010 16.09 A: r-h...@stat.math.ethz.ch Cc: mau...@alice.it Oggetto: RE: R: [R] website address for the pseuso-XLS files It is OpenOffice 2.0 (as updated to openoffice.org-core, dfsg.2-7etch9 Sat Jan 16 2010) running on Linux (Debian Etch, originally installed Sept 2007), so none of it is particularly recent. The command to view the files is like: oocalc Prostatic_Neoplasm-miRNAs.DiseaseTargets.xls Ted. On 25-May-10 13:54:06, mau...@alice.it wrote: > Thank you. > May I know the version of your OO and the operating system it runs on ? > I use Linux/SuSE 11.1 running OO 3.0.0.9-1.9 > Maura > > > -----Messaggio originale----- > Da: ted.hard...@manchester.ac.uk [mailto:ted.hard...@manchester.ac.uk] > Inviato: mar 25/05/2010 15.22 > A: r-h...@stat.math.ethz.ch > Cc: mau...@alice.it > Oggetto: Re: [R] website address for the pseuso-XLS files > > To be more precise: These seem to be files in XML (Extended Markup > Language) format, or a variant thereof, not HTML. This is understood > by recent versions of Excel. The "xls" extension is deceptive here! > > Maura: You originally wrote > > "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 had no problem myself opening them with oocalc (the OpenOffice > spreadsheet program), and I get a table (which looks just like > similar tables I was able to view earlier, in a browser, on the > mirWalk website). However, this would not allow me to save/export > in (say) CSV format. > > But, by highlighting and them pasting into a text file, I was then > able to convert to CSV format. I shall send the results privately > to Maura. > > Ted. > > > On 25-May-10 12:47:45, Peter Ehlers wrote: >> Maura, >> >> These are html files. Rename the downloaded file(s) to *.html and >> open with your favourite browser. Follow links from there. >> >> -Peter Ehlers >> >> On 2010-05-25 6:24, mau...@alice.it wrote: >>> http://gigamail.rossoalice.alice.it/messages/readMessageFrameset.aspx? >>> D >>> eliveryID=ba40cf18-29db-4404-a3ce-af26f760ecf9 >>> >>> Please, paste the website address above shown in your web browser >>> address field. >>> Make sure the whole string is pasted with no space or any other >>> character. >>> Telecom couldn't generate more clumsy website addresses .... Sorry >>> for >>> that. >>> >>> Thank you in advance, >>> Maura >>> >> >> ______________________________________________ >> R-help@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. > > -------------------------------------------------------------------- > E-Mail: (Ted Harding) <ted.hard...@manchester.ac.uk> > Fax-to-email: +44 (0)870 094 0861 > Date: 25-May-10 Time: 14:21:51 > ------------------------------ XFMail ------------------------------ > > > > Alice Messenger ;-) chatti anche con gli amici di Windows Live > Messenger e tutti i telefonini TIM! > Vai su -------------------------------------------------------------------- E-Mail: (Ted Harding) <ted.hard...@manchester.ac.uk> Fax-to-email: +44 (0)870 094 0861 Date: 25-May-10 Time: 15:09:53 ------------------------------ XFMail ------------------------------ tutti i telefonini TIM! [[alternative HTML version deleted]] ______________________________________________ R-help@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.