Try this:
library(XML)
doc <- xmlTreeParse("adodb.xml", useInternalNodes = TRUE)
Lines <- xpathSApply(doc, "//z:row",
function(x) do.call(paste, as.list(xmlAttrs(x
DF <- read.table(textConnection(Lines), col.names =
xpathSApply(doc, "//s:AttributeType", function(x) xmlAttrs(x)[
Dieter Menne pointed out that the (small) xml attachment didn't make it.
Here is an in-line version (see end of message). Let's hope it works
this time.
I'm struggling with interpreting XML files created by ADODB as
data.frames and I'm looking for advice.
Note:
This xlm contains a result set
2 matches
Mail list logo