> -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of [email protected] > Sent: Sunday, July 05, 2009 11:28 PM > To: Martin Morgan > Cc: [email protected] > Subject: [R] R: R: Is there a way to extract some fields data > from HTML pages through any R function ? > > It helps. But it is overly sophisticated. > I have already downloaded and used the Excel file containing > the validated stuff. > > Since there are R commands to download gzip as well as FASTA > files, I wonder whether it is possible to > automatically download the Excel file from > http://mirecords.umn.edu/miRecords/download.php > Actually the latter may not be the actual file URL because it > is necessary to click on the word "here" to download the file. > > Thank you, > Maura > Maura,
I haven't seen a response to your question (however, I just may have missed it, or you mave have received an off-line response). I went to the URL above and found that the Excel file is at http://mirecords.umn.edu/miRecords/download_data.php?v=1 I think you could use the read.xls() function from the gdata package to get the file, something like this library(gdata) df <- read.xls("http://mirecords.umn.edu/miRecords/download_data.php?v=1";) Hope this is helpful, Dan Daniel Nordlund Bothell, WA USA ______________________________________________ [email protected] 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.
