Excel, XML, and Datatable

[maksim310]

I have a datatable, how do I export the datatable to XML file that can be read by Excel (as early as Excel 2003). I think I need to combine the data with the schema somehow.

I also have multiple datatables that need to be shown on different sheets of the same Excel file. How is this possible.

And thirdly, I couldn't find any good tutorial on generating Crystal Reports from the datatables or XML for vb.net.

Thank You.

 

[giadich]

I think excel can open xml file so just go about creating your xml file as normal.

if you are adding multiple sheet then xml is out of the question. Anyone got a solution for this?

as for CR, I always headed for BusinessObjects.com. Not a very good resources for getting the work done but it could be useful.

 

[maksim310]

Thanks,

Whenever I try to open an XML file generated simply by datatable1.writexml(c:\blahblah.xml) then Excel says no Schema is attached to it and therefore it will make one up. How do I attach the schema to it?

My clients might get confused and think it's a bug, I would rather thah message din't pop up.

-Max

 

[giadich]

if you specify a stylesheet, it should take care of that issue.

 

[maksim310]

OK, how do I specify a stylesheet?

 

[cjard]

I have a datatable, how do I export the datatable to XML file that can be read by Excel (as early as Excel 2003). I think I need to combine the data with the schema somehow.

I also have multiple datatables that need to be shown on different sheets of the same Excel file. How is this possible.

And thirdly, I couldn't find any good tutorial on generating Crystal Reports from the datatables or XML for vb.net.

Thank You.

Search the forum for ExcelableDataSet and look for posts by me. Be aware that some hits will simply be me answering this same question with that keyword above, so start by looking through the older posts first