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.

Reply via email to