Last post Dec 16, 2015 03:17 AM by Zhi Lv - MSFT
Dec 15, 2015 07:11 PM|SSK_Nani|LINK
I have Dataset with two data tables, Now I want to export these two tables into Excel file with two sheets.
I need a help like how to convert into Excel using XML and XSLT.
In Datatable 1, columns are dynamically generated.
Dec 16, 2015 03:17 AM|Zhi Lv - MSFT|LINK
I suggest you could refer to the following code:
string procInfo = "type='text/xsl' href='" + "\\transform.xslt" + "'";
XmlTextWriter tw = new XmlTextWriter(XMLPath ,null);
DataSet ds = GetData();
ds.Tables.TableName = "Products";
More details, please refer to these articles: