public ActionResult Export()
{
try
{
WorkbookDesigner designer = new WorkbookDesigner();
var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Download/"), "SimTemplate.xls");
designer.Workbook = new Workbook(path);
var worksheet = designer.Workbook.Worksheets[0];
var data = _systemService.GetSims();
designer.SetDataSource("Export", data);
//Process the markers
designer.Process(false);
//Save the Excel file.
System.IO.Stream stream = Response.OutputStream;
worksheet.Name = "DanhSachSim_" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-disposition",
"attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls");
Response.Clear();
Response.BufferOutput = true;
designer.Workbook.Save(stream, SaveFormat.Excel97To2003);
Response.Flush();
return new EmptyResult();
}
catch (Exception)
{
return new EmptyResult();
}
}
Data Source: &=Export.Name .....
No comments:
Write comments