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());
}
