public static string ExportToExcel(List <IndexMetadataHandler.ResultPair> data, List <IndexMetadataHandler.ProcessResultItem> errorsList)
{
var tempFile = String.Concat(System.IO.Path.GetTempFileName(), ".xlsx");
using (XLWorkbook wb = new XLWorkbook())
{
ExportExcelIndexMetadataHandler handler = new ExportExcelIndexMetadataHandler();
foreach (IndexMetadataHandler.ResultPair pair in data)
{
DataTable result = handler.FillDataTable(pair.TotalContentHeader, pair.TotalContentData);
var resultaat = wb.Worksheets.Add(result, String.Format("P02 - Indexeren ({0})", pair.Name));
resultaat.Columns().AdjustToContents();
}
DataTable errors = handler.FillDataTableErrors(errorsList);
if (errorsList.Count > 0)
{
var fouten = wb.Worksheets.Add(errors, "P02 - Indexeren (Fouten)");
fouten.Columns().AdjustToContents();
}
wb.SaveAs(tempFile);
}
return(tempFile);
}
private void CreateExcel(List <ResultPair> data)
{
try
{
var excelOutput = ExportExcelIndexMetadataHandler.ExportToExcel(data, _validationResultList);
FileInfo excelFile = new FileInfo(excelOutput);
excelFile.MoveTo(Path.Combine(TargetFolder, "IndexMetadataHandler.xlsx"), true);
}
catch (Exception e)
{
throw new Exception("Re-throw exception in CreateExcel.", e);
}
finally { }
}
