This is a VBA app (run in Excel 2007) that I developed to automatically import online XML data into a Excel file every 1 minute.
Here is the download link
XML Data Importer
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
This is interesting. I need to parse data in
ReplyDeleteXML Document to Excel Worksheet. This is the
XML file:
Cust1234
Smith
New York
MP3 Player
Radio
This well formed XML document feeds to Excel
2007 using MS VBA code. I was successful
with using DOMDocument and IXMLDOMElement to
import the Name, City, and Product.
However, the xa:MeContext id, Data1 id, Data2
id, CustID, and order Orderid number
won't export to Excel sheet. This should be
simple. This is my first post here.
Each Excel row has the following headers with
data filled from XML document:
MeContextID--vsData1--VsData2--CustID--Name--City--OrderID--Product--OrderID--Product
java computer programming snippets
ReplyDeletejava code | Read an Xml file