Question
D Gopinath on Thu, 18 Oct 2012 07:24:58
I have to import data from datatable to Xml and then export into excel?
Sponsored
Replies
Hirendra Sisodiya on Thu, 18 Oct 2012 08:01:14
you can use the WriteXML() method for doing this, as shown here:
DataTable dt = new DataTable("tblStudent");
dt.Columns.Add("Name");
dt.Columns.Add("Id");
dt.Rows.Add();
dt.Rows[0]["Name"] = "John";
dt.Rows[0]["Id"] = "1";
dt.Rows.Add();
dt.Rows[1]["Name"] = "Ram";
dt.Rows[1]["Id"] = "2";
dt.WriteXml("C:\\test.xml");
You can down load the full code sample to export data table to excel format from here:
http://code.msdn.microsoft.com/vstudio/Export-DataTable-object-to-b3e2c1f0