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 { } }