c# aspose 模版 简单导出execl

 

感谢

ismallboy 

思路主要是根据他的文章，代码有所改进

 

思路: 根据datatable 导出到模版execl 以文件流形式输出

/// <summary>
/// 返回Excel文件流
/// </summary>
/// <param name="model">数据datatable</param>
/// <param name="templateFileName">模板文件，要全路径</param>
/// <param name="sheetName">工作簿名称</param>
/// <returns></returns>
public static void ExpToExecl(DataTable model, string templateFileName, string sheetName)
{
WorkbookDesigner designer = new WorkbookDesigner();
designer.Workbook = new Workbook(templateFileName);

designer.SetDataSource(model);
designer.Process();
if (!string.IsNullOrEmpty(sheetName))
{
designer.Workbook.Worksheets[0].Name = sheetName;
}
#region 输出到Excel
using (MemoryStream ms = new MemoryStream())
{

designer.Workbook.Save(ms, new OoxmlSaveOptions(SaveFormat.Xlsx));//默认支持xls版，需要修改指定版本
System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
System.Web.HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
System.Web.HttpContext.Current.Response.BinaryWrite(ms.ToArray());
designer.Workbook = null;
System.Web.HttpContext.Current.Response.End();
}
#endregion
}