感谢

 

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

 

思路: 根据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

}