[R] Reading in an XLS (really XML) file from website

2015-02-27 Thread Bos, Roger
All, I am trying to read the SP 500 constituents from the iShares website using the following code: URL - http://www.ishares.com/us/239726/fund-download.dl; setInternet2(TRUE) download.file(url=URL, destfile=temp.xls) out - readWorksheetFromFile(file=temp.xls, sheet=Holdings,

Re: [R] Reading in an XLS (really XML) file from website

2015-02-27 Thread Raghuraman Ramachandran
This works: Change the destination directory to suit you. MyURL1 = http://www.ishares.com/us/239726/fund-download.dl; download.file(MyURL1,paste(C:/Data/Rtest1,date1,r.xls,sep=),method=wget,quiet=TRUE,mode=wb, extra=--header=\User-Agent: Mozilla/5.0 (X11; Linux x86_64;

Re: [R] Reading in an XLS (really XML) file from website

2015-02-27 Thread John McKown
On Fri, Feb 27, 2015 at 10:01 AM, Bos, Roger roger@rothschild.com wrote: All, I am trying to read the SP 500 constituents from the iShares website using the following code: URL - http://www.ishares.com/us/239726/fund-download.dl; setInternet2(TRUE) download.file(url=URL,