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