The ishares website has the S&P 500 stocks you can download as a XLS file, which opens fine in Excel, but I am not able to open it in R due to what seems to be invalid XML formatting. I tried using XLConnect and XML as shown below. Does anyone know a workaround or can point out what I am doing wrong. Here is my reproducible code:
temp <- "https://www.ishares.com/us/239726/fund-download.dl" fname <- "ivv.xls" download.file(url = temp, destfile = fname) readWorksheetFromFile(fname) library(XML) xmlfile <- xmlTreeParse(fname) 09:06:17 > readWorksheetFromFile(fname) Error: InvalidFormatException (Java): Your InputStream was neither an OLE2 stream, nor an OOXML stream 09:06:17 > library(XML) 09:06:25 > xmlfile <- xmlTreeParse(fname) Opening and ending tag mismatch: Style line 14 and Style Error: 1: Opening and ending tag mismatch: Style line 14 and Style Thanks in advance, Roger This message and any attachments are for the intended recipient's use only. This message may contain confidential, proprietary or legally privileged information. No right to confidential or privileged treatment of this message is waived or lost by an error in transmission. If you have received this message in error, please immediately notify the sender by e-mail, delete the message, any attachments and all copies from your system and destroy any hard copies. You must not, directly or indirectly, use, disclose, distribute, print or copy any part of this message or any attachments if you are not the intended recipient. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.