import excel xml Spreadsheet to dataset

krissri_mtc · May 29th, 2007, 11:02 PM

i have to import a excel xml spreadsheet to dataset in c#.net without using office dll on the server.since the xml is not a well formed xml ds.readxml is unable to read it.

mhkay · May 30th, 2007, 04:35 AM

>the xml is not a well formed xml

I don't understand this statement. If it's not well-formed XML then it's not XML.

It's reasonably easy to export an Excel spreadsheet as XML. It's quite hard to process the resulting XML in XSLT because of its complexity, but it can be done.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

bonekrusher · May 30th, 2007, 07:21 AM

The XSLT Cookbook has a great XSLT code to transform excel xml spreadsheets to a "cleaner" XML files.