public static byte[] ToXlsx <T>(this ExtensionWorksheet <T> lastWorksheet)
{
lastWorksheet.AppendWorksheet();
var package = lastWorksheet.Workbook.Package;
using (var stream = new MemoryStream())
{
package.SaveAs(stream);
package.Dispose();
return(stream.ToArray());
}
}
/// <summary>
/// starts a new worksheet
/// </summary>
/// <typeparam name="T"></typeparam>
/// <typeparam name="K"></typeparam>
/// <param name="previousSheet"></param>
/// <param name="rows"></param>
/// <param name="name"></param>
/// <returns></returns>
public static ExtensionWorksheet <T> NextWorksheet <T, K>(this ExtensionWorksheet <K> previousSheet, IList <T> rows, string name, Action <ExcelColumn> configureColumn = null, Action <ExcelRange> configureHeader = null, Action <ExcelRange> configureHeaderRow = null, Action <ExcelRange, T> configureCell = null)
{
previousSheet.AppendWorksheet();
var worksheet = new ExtensionWorksheet <T>()
{
Name = name,
Workbook = previousSheet.Workbook,
Rows = rows,
Columns = new List <ExtensionColumn <T> >(),
ConfigureHeader = configureHeader ?? previousSheet.ConfigureHeader,
ConfigureColumn = configureColumn ?? previousSheet.ConfigureColumn,
ConfigureHeaderRow = configureHeaderRow ?? previousSheet.ConfigureHeaderRow,
ConfigureCell = configureCell
};
return(worksheet);
}
public static ExcelPackage ToPackage <T>(this ExtensionWorksheet <T> lastWorksheet)
{
lastWorksheet.AppendWorksheet();
return(lastWorksheet.Workbook.Package);
}
