public static byte[] ExportToBuffer(IWorkbook workbook, params SheetFormatterContainer[] containers) { foreach (var container in containers) { var sheet = workbook.GetSheet(container.SheetName); var context = new SheetFormatterContext(sheet, container.Formatters); context.Format(); } return(workbook.SaveToBuffer()); }
public static byte[] ExportToBuffer(string templateFile, params SheetFormatterContainer[] containers) { var workbook = LoadTemplateWorkbook(templateFile); foreach (var container in containers) { var sheet = workbook.GetSheet(container.SheetName); //加载第一个sheet var context = new SheetFormatterContext(sheet, container.Formatters); context.Format(); } return(workbook.SaveToBuffer()); }