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: http://r.789695.n4.nabble.com/Download-a-file-from-url-tp4642985p4646215.html Sent from the R help mailing list archive at Nabble.com.
Hello, Your page returns "access denied": library(RCurl) url <- "http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls" xls <- getURL(url) cat(xls) <HTML><HEAD> <TITLE>Access Denied</TITLE> </HEAD><BODY> <H1>Access Denied</H1> You don't have permission to access "http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls" on this server.<P> Reference #18.f0241c2.1350314817.23d7e0e0 </BODY> </HTML> Also, start a new thread when you want to ask a new question. Hope this helps, Rui Barradas Em 15-10-2012 09:57, veepsirtt escreveu:> 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: http://r.789695.n4.nabble.com/Download-a-file-from-url-tp4642985p4646215.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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.
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 <veepsirtt at gmail.com> 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: http://r.789695.n4.nabble.com/Download-a-file-from-url-tp4642985p4646215.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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.