public byte[] StreamExcelDocument <T>(List <T> data) where T : class, new()
{
using (var stream = new MemoryStream())
using (var document = SpreadsheetDocument.Create(stream, SpreadsheetDocumentType.Workbook, true))
{
var ds = new DataSet();
ds.Tables.Add(EPCore.ListToDataTable(data));
document.WriteExcelFile(ds, Stylesheet);
return(stream.ToArray());
}
}
public byte[] StreamExcelDocument <T>(Dictionary <string, List <T> > sheetsData) where T : class, new()
{
using (var stream = new MemoryStream())
using (var document = SpreadsheetDocument.Create(stream, SpreadsheetDocumentType.Workbook, true))
{
var ds = new DataSet();
foreach (var data in sheetsData)
{
ds.Tables.Add(EPCore.ListToDataTable(data.Value, data.Key));
}
document.WriteExcelFile(ds, Stylesheet);
return(stream.ToArray());
}
}
