public static byte[] ToExcelWorkbook <T>(this IEnumerable <T> list, ExcelFormattingSettings formattingSettings = null)
{
if (formattingSettings == null)
{
formattingSettings = ExcelFormattingSettings.Default <T>();
}
// Create Excel workbook
using var wb = new XLWorkbook();
AddPage(wb, formattingSettings.SheetName, list, formattingSettings);
// Return as byte array
return(wb.GetAsByteArray());
}
public static byte[] ToExcelWorkbook(this IEnumerable <QueryResult> queryResults, ExcelFormattingSettings formattingSettings = null)
{
if (formattingSettings == null)
{
formattingSettings = ExcelFormattingSettings.Default("Sheet1");
}
// Create Excel package
using var wb = new XLWorkbook();
foreach (var result in queryResults)
{
AddQueryResultPage(wb, result, formattingSettings);
}
// Return as byte array
return(wb.GetAsByteArray());
}
