- protected void btnExcel_Click(object sender, EventArgs e)
- {
- GrapeCity.ActiveReports.Export.Excel.Section.XlsExport XlsExport1 = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
- System.IO.MemoryStream ms = new System.IO.MemoryStream();
- XlsExport1.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx;
- GenerateReport();//加载模板和数据源
- XlsExport1.Export(report.Document, ms);
- Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
- Response.AddHeader("content-disposition", Server.UrlPathEncode("attachment;filename=MyExport.xlsx"));
- Response.BinaryWrite(ms.ToArray());
- Response.End();
- }
复制代码 这是导出按钮的实现,附件是模板,看看是否有问题。
|