G
Guest
I have a dataset with multiple tables I need exported to Excel. I can get it
into Excel into one worksheet however I want there to be one worksheet for
each datatable in the dataset. If I dump my xml string from the getXML method
into Excel it puts all the data from the tables into the same worksheet.
I am using the XMLImportXML method that's available with Office 2003.
Do I have to loop through each datatable and use getXML and XMLImportXML
separately? Is there something that could be generated from perhaps the
getXMLSchema method that tells Excel to put each table in a separte worksheet?
into Excel into one worksheet however I want there to be one worksheet for
each datatable in the dataset. If I dump my xml string from the getXML method
into Excel it puts all the data from the tables into the same worksheet.
I am using the XMLImportXML method that's available with Office 2003.
Do I have to loop through each datatable and use getXML and XMLImportXML
separately? Is there something that could be generated from perhaps the
getXMLSchema method that tells Excel to put each table in a separte worksheet?