ExcelFile RunReport(LangDataList langs)
{
ExcelFile Result = new XlsFile(Path.Combine(NSBundle.MainBundle.BundlePath, "report.template.xls"), true);
using (FlexCelReport fr = new FlexCelReport(true))
{
fr.AddTable("lang", langs.items);
fr.Run(Result);
}
return(Result);
}
async Task <ExcelFile> RunReport(LangDataList langs)
{
ExcelFile Result = new XlsFile(true);
await Result.OpenAsync(await StorageFile.GetFileFromApplicationUriAsync(new Uri("ms-appx:///Assets/Templates/report.template.xls")));
using (FlexCelReport fr = new FlexCelReport(true))
{
fr.AddTable("lang", langs.items);
fr.Run(Result);
}
return(Result);
}
async Task <ExcelFile> RunReport(LangDataList langs)
{
ExcelFile Result = new XlsFile(true);
var template = await StorageFile.GetFileFromApplicationUriAsync(new Uri("ms-appx:///Assets/Templates/report.template.xlsx"));
using (var templateStream = await template.OpenStreamForReadAsync())
{
Result.Open(templateStream);
using (FlexCelReport fr = new FlexCelReport(true))
{
fr.AddTable("lang", langs.items);
fr.Run(Result);
}
}
return(Result);
}
ExcelFile RunReport(LangDataList langs)
{
ExcelFile Result = new XlsFile(true);
using (var template = Assets.Open("report.template.xls"))
{
//we can't load directly from the asset stream, as we need a seekable stream.
using (var memtemplate = new MemoryStream())
{
template.CopyTo(memtemplate);
memtemplate.Position = 0;
Result.Open(memtemplate);
}
}
using (FlexCelReport fr = new FlexCelReport(true))
{
fr.AddTable("lang", langs.items);
fr.Run(Result);
}
return(Result);
}
