It could be as easy as System.Data.DataTable.WriteXml(yourFileName).
Hi mohnston, to do this, I must build up the xml content at first. For Excel and OpenOffice the code for content and formatting already exists.
...
Ah, the formatting would be an issue since WriteXML just writes the data to an XML file.
When you open it in a program (Excel or ?) you get just the basic data, columns and rows.
Which is why you provide pre-processing instructions that point to an XSL, as such:
<?xml-stylesheet type="text/xsl" href="weld report format (BETA1).xsl"?>
When Excel opens the file, it asks the user which stylesheet to use and lists the provided one as a default.