excel to xml

[Guest]

In my application my requirement is i have one excel file sheet, i want to
convert that excel file to xml file?

 

[sloan]

Check these 2 entries:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry

http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!119.entry

Start with the second link , then go to the first one.


public class ExcelXMLConverter

will give you "excel xml".
the first KB will show you how to convert it to "more friendly" xml if need
be.


Having said that, you need to know that it isn't recommended to use excel
object library objects on the IIS server.


Another method is to use LoadDataSet against an excel file, and then use the
ds.WriteXml() method.

It depends on what you're after.

http://support.microsoft.com/kb/306572

 

[Mark Rae [MVP]]

http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!119.entry

Having said that, you need to know that it isn't recommended to use excel
object library objects on the IIS server.

Not recommended, and not supported, because of the serious risks involved -
please don't advise anyone to use server-side Office automation...