protected void exportDataSetByTemplateBtn_Click(object sender, EventArgs e)
{
XmlDocument xmlDoc = WebXmlDocumentCache.GetXmlDocument("Interco upload template.xml");
xmlDoc.PreserveWhitespace = true;
WorkbookNode workbook = new WorkbookNode();
workbook.LoadXml(xmlDoc.OuterXml);
DataTable table = CreateDemoDataTable();
DataViewExportOptions options = new DataViewExportOptions()
{
ExportColumnHeader = false
};
table.DefaultView.FillIntoSpreadSheet(workbook, "Sheet1", options);
Response.AppendHeader("CONTENT-DISPOSITION",
string.Format("{0};filename={1}", "inline", HttpUtility.UrlEncode("test.xml")));
Response.ContentType = "text/xml";
Response.Clear();
workbook.Save(Response.OutputStream);
Response.End();
}
