Hello Prof Brian Ripley
I installed wget for windows from http://users.ugent.be/~bpuype/wget/
<http://users.ugent.be/~bpuype/wget/> and got the results
very thanks
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', extra="-U 'Mozilla/5.0
> (X11; Linux) Gecko Firefox/5.0'")
--2012-10-16 14:44:36-- http://(x11;/
Resolving (x11;... failed: Unknown host.
wget: unable to resolve host address `(x11;'
--2012-10-16 14:44:36-- http://linux)/
Resolving linux)... failed: Unknown host.
wget: unable to resolve host address `linux)'
--2012-10-16 14:44:36-- http://gecko/
Resolving gecko... failed: Unknown host.
wget: unable to resolve host address `gecko'
--2012-10-16 14:44:36-- http://firefox/5.0'
Resolving firefox... failed: Unknown host.
wget: unable to resolve host address `firefox'
--2012-10-16 14:44:37--
http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls
Resolving www.nseindia.com... 124.124.252.97, 124.124.252.107
Connecting to www.nseindia.com|124.124.252.97|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 24576 (24K) [application/vnd.ms-excel]
Saving to: `C:/Users/Acer/AppData/Local/Temp/Rtmpqa0fd0/file1828c40257e'
0K .......... .......... .... 100%
5.26K=4.6s
2012-10-16 14:44:44 (5.26 KB/s) -
`C:/Users/Acer/AppData/Local/Temp/Rtmpqa0fd0/file1828c40257e' saved
[24576/24576]
FINISHED --2012-10-16 14:44:44--
Downloaded: 1 files, 24K in 4.6s (5.26 KB/s)
> wb = loadWorkbook(local.xls.file, create=F)
> data = readWorksheet(wb, sheet=1)
> na.omit(data)
FII.DERIVATIVES.STATISTICS.FOR.12.Oct.2012 Col1 Col2
Col3
3 INDEX FUTURES 40230.0 1142.001965025
51478.0
4 INDEX OPTIONS 525745.0 14990.371
492126.0
5 STOCK FUTURES 35248.0 1028.378075
45162.0
6 STOCK OPTIONS 105001.0 3212.669375
105553.0
Col4 Col5 Col6
3 1430.472715225 603867.0 15419.5277629
4 14070.52175 1783758.0 50627.34217375
5 1308.1875375 1041481.0 30630.1147675
6 3230.074875 80391.0 2505.014379375
>
-----------------------------------------------------------------------------------------------------------------------------
--
View this message in context:
http://r.789695.n4.nabble.com/Download-a-file-from-url-tp4642985p4646313.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
