Hi,
The way I do it is use DataTables WriteXml method.
For e.g.
DataTable dt = new DataTable("Test");
dt.Columns.Add("Code", typeof(string));
dt.Columns.Add("Price", typeof(int));
DataRow dr = dt.NewRow();
dr["Code"] = "ABC";
dr["Price"] = 12;
dt.Rows.Add(dr);
DataRow dr1 = dt.NewRow();
dr1["Code"] = "PQR";
dr1["Price"] = 1;
dt.Rows.Add(dr1);
dt.WriteXml("D:/Test.xls");
You can pass your path to writexml here.
Regards,
Praneet