You actually have an XSD that describes that XML structure? Wow.
Generating an XML document from an XSD can't yield a meaningful result, so you'd best forget about that.
If you save the Excel worksheet as an XML spreadsheet you could use XSLT to transform that XML document into an XML document that matches your XSD.
How to do that using Java you can read about here. You could then validate the resulting XML against your XSD. There's an example on how to do that in our FAQ.
Build a man a fire, and he'll be warm for a day. Set a man on fire, and he'll be warm for the rest of his life.
sai rama krishna
Joined: May 29, 2009
>>If you save the Excel worksheet as an XML spreadsheet you could use XSLT to transform that XML document into an XML document that matches your XSD.
I have excel worksheets with about 50 sheets in that for different cities. How do I make it as XML spread sheet to transform to XML document using XSLT. Please advise