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