XML data parsing
This is XML i have, i want to parse data alone using Excel macro or VB.NET how to i can do it? any one help me to do it?
Mon Aug 18 16:21:15 UTC 2008b0fb0e9ffde9f637b605dc30b49062a0Time Trend Product ViewKraft-Hotdogs
Software
This is XML i have, i want to parse data alone using Excel macro or VB.NET how to i can do it? any one help me to do it?
Mon Aug 18 16:21:15 UTC 2008b0fb0e9ffde9f637b605dc30b49062a0Time Trend Product ViewKraft-Hotdogs
by vvhari123 Accepted solution
by Former member Accepted solution
Choose the right XML parsing technique for your Java applications.
Efficient parsing of XML documents is more and more critical as XML gets adopted more widely. It is very important to have an efficient way to parse XML data, especially in applications that are intended to handle large volumes. Improper parsing can result in excessive memory usage and processing times that can hurt scalability.
Several types of XML parsers are available. Which one is right for your situation? This article examines three popular XML parsing techniques for Java and shows you how to choose the correct method, based on the requirements of your application.
An XML parser takes as input a raw serialized string and performs certain operations on it. First it checks the syntactic well-formedness of the XML data, making sure that the start tags have matching end tags and that there are no overlapping elements. Most parsers also implement validation against the Document Type Definition (DTD) or the XML Schema to verify that the structure and content are as you specified. Finally, the parsing output provides access to the content of the XML document via programmatic APIs.
There are three popular XML parsing techniques for Java:
* Document Object Model (DOM), a mature standard from W3C
* Simple API for XML (SAX), the first widely adopted API for XML in Java and a de facto standard
* Streaming API for XML (StAX), a promising new parsing model introduced in JSR-173
Each of these techniques has benefits and drawbacks.
The following XML document, books.xml, describes a book catalog and is used in the examples in this article:
XML in a Nutshell
Elliotte Rusty Harold, W. Scott Means
39.95
Who Moved My Cheese
Spencer, M.D. Johnson, Kenneth H. Blanchard
19.95
More here:
http://www.oracle.com/technology/oramag/oracle/03-sep/o53devxml.html
Please post back if you have any more problems or questions.
by tony hopkinson Accepted solution
In .net you can turn it into a dataset, after a bit of work but that can get really messy.
If you want to get content from it in .net, look up the XMLDocument class.
You'll need to pick up a bit of Xpath, but if you start simple, it's not too bad.
This discussion is closed to new replies.
Sort by Trending