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[] ToExcelPackage <T>(this IEnumerable <T> list, ExcelFormattingSettings formattingSettings = null)
{
if (formattingSettings == null)
{
formattingSettings = ExcelFormattingSettings.Default <T>();
}
// Create Excel package
using (var p = new ExcelPackage())
{
AddPage(p, formattingSettings.SheetName, list, formattingSettings);
// Return as byte array
return(p.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());
}
public static byte[] ToExcelPackage(this IEnumerable <QueryResult> queryResults, ExcelFormattingSettings formattingSettings = null)
{
if (formattingSettings == null)
{
formattingSettings = ExcelFormattingSettings.Default("Sheet1");
}
// Create Excel package
using (var p = new ExcelPackage())
{
foreach (var result in queryResults)
{
AddQueryResultPage(p, result, formattingSettings);
}
// Return as byte array
return(p.GetAsByteArray());
}
}
public static byte[] ToExcelPackage <T>(this Dictionary <string, IEnumerable <T> > lists, ExcelFormattingSettings formattingSettings = null)
{
if (formattingSettings == null)
{
formattingSettings = ExcelFormattingSettings.Default <T>();
}
// Create Excel package
using (var p = new ExcelPackage())
{
// Create a sheet
var ws = p.Workbook.Worksheets.Add(formattingSettings.SheetName);
foreach (var list in lists)
{
AddPage(p, list.Key, list.Value, formattingSettings);
}
// Return as byte array
return(p.GetAsByteArray());
}
}
