/// <summary> /// 导出格式化处理后的文件到二进制文件流 /// </summary> /// <param name="templateFile"></param> /// <param name="sheetFormatters"></param> /// <returns></returns> public static byte[] ExportToBuffer(string templateFile, params SheetFormatter[] sheetFormatters) { IWorkbook workbook = NPOIHelper.LoadWorkbook(templateFile); foreach (SheetFormatter sheetFormatter in sheetFormatters) { sheetFormatter.Format(workbook); } return(workbook.SaveToBuffer()); }
/// <summary> /// 导出格式化处理后的文件到内存流 /// </summary> /// <param name="templateFile"></param> /// <param name="sheetFormatters"></param> /// <returns></returns> public static Stream ExportToStream(string templateFile, params SheetFormatter[] sheetFormatters) { IWorkbook workbook = NPOIHelper.LoadWorkbook(templateFile); foreach (SheetFormatter sheetFormatter in sheetFormatters) { sheetFormatter.Format(workbook); } var ms = new MemoryStream(); workbook.Write(ms); return(ms); }
/// 导出到Web /// <param name="templateFile"></param> /// <param name="targetFile"></param> /// <param name="containers"></param> public static void ExportToWeb(string templateFile, string targetFile, params SheetFormatterContainer[] containers) { #region 参数验证 if (string.IsNullOrEmpty(templateFile)) { throw new ArgumentNullException("templateFile"); } if (!File.Exists(templateFile)) { throw new FileNotFoundException(templateFile + " 文件不存在!"); } #endregion 参数验证 IWorkbook workbook = NPOIHelper.LoadWorkbook(templateFile); ExportToWeb(workbook, targetFile, containers); }
/// 导出格式化处理后的文件到二进制文件流 /// <param name="templateFile"></param> /// <param name="containers"></param> /// <returns></returns> public static byte[] ExportToBuffer(string templateFile, params SheetFormatterContainer[] containers) { var workbook = NPOIHelper.LoadWorkbook(templateFile); return(ExportToBuffer(workbook, containers)); }