Download a file from url
Have you tried downloading it manually using a web browser or similar? If so, compare that downloaded file to that you get from download.file() and see if they're the same. If the same, the problem is elsewhere (which is not unlikely to be the case). /H
On Mon, Oct 15, 2012 at 6:15 PM, veepsirtt <veepsirtt at gmail.com> wrote:
Hi Henrik, i included the mode='wb' but gives me this error. What is the other method to download the excel file?. With kind regards veepsirtt library(XLConnect)
url = "http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls" local.xls.file = tempfile() download.file(url, local.xls.file, method='wget', mode='wb',extra="-U
'Mozilla/5.0 (X11; Linux) Gecko Firefox/5.0'") Warning message: In download.file(url, local.xls.file, method = "wget", mode = "wb", : download had nonzero exit status
wb = loadWorkbook(local.xls.file, create=F)
Error: FileNotFoundException (Java): File 'filed0c141444d8' could not be found - you may specify to automatically create the file if not existing.
data = readWorksheet(wb, sheet=1)
Error in readWorksheet(wb, sheet = 1) : error in evaluating the argument 'object' in selecting a method for function 'readWorksheet': Error: object 'wb' not found
On Mon, Oct 15, 2012 at 11:58 PM, Henrik Bengtsson-3 [via R] < ml-node+s789695n4646268h88 at n4.nabble.com> wrote:
You didn't say what errors you've got but you probably wants to specify argument mode="wb" in your download.file() call, cf. https://stat.ethz.ch/pipermail/r-devel/2012-August/064739.html /Henrik On Mon, Oct 15, 2012 at 1:57 AM, veepsirtt <[hidden email]<http://user/SendEmail.jtp?type=node&node=4646268&i=0>> wrote:
Hi Download the xls file from this link http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls <http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls> I tried this --------------------------------------------------------------- library(XLConnect) url = "http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls" local.xls.file = tempfile() download.file(url, local.xls.file) wb = loadWorkbook(local.xls.file, create=F) data = readWorksheet(wb, sheet=1) View(data) --------------------------------------------------------------- no results ... kindly help me thanks veepsirtt -- View this message in context:
Sent from the R help mailing list archive at Nabble.com.
______________________________________________ [hidden email] <http://user/SendEmail.jtp?type=node&node=4646268&i=1>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. ______________________________________________ [hidden email] <http://user/SendEmail.jtp?type=node&node=4646268&i=2>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. ------------------------------ If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/Download-a-file-from-url-tp4642985p4646268.html To unsubscribe from Download a file from url, click here<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4642985&code=dmVlcHNpcnR0QGdtYWlsLmNvbXw0NjQyOTg1fDY5NzkzMTE3Nw==> . NAML<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
-- View this message in context: http://r.789695.n4.nabble.com/Download-a-file-from-url-tp4642985p4646295.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]]
______________________________________________ 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.