public static void WriteLinks(this Workbook wb, ILinksAnalysis links)
{
if (wb == null)
{
throw new ArgumentNullException(nameof(wb));
}
if (links == null)
{
throw new ArgumentNullException(nameof(links));
}
wb.DeleteTargetWorksheet(LinksSheetName);
wb.DeleteTargetWorksheet(FilesSheetName);
wb.DeleteTargetWorksheet(ErrorsSheetName);
if (links.Links.Count == 0 && links.Errors.Count == 0)
{
MessageBox.Show("No external links found!", "", MessageBoxButtons.OK, MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1);
}
else
{
var wsLinks = wb.CreateTargetWorksheet(LinksSheetName);
var wsFiles = wb.CreateTargetWorksheet(FilesSheetName);
var wsErrors = wb.CreateTargetWorksheet(ErrorsSheetName);
wsLinks.WriteLinksAnalysis(links);
wsFiles.WriteLinksFiles(links.Files);
wsErrors.WriteLinksErrors(links.Errors);
wb.Application.StatusBar = false;
}
}
private static Worksheet CreateTargetWorksheet(this Workbook wb, string sheetName)
{
wb.DeleteTargetWorksheet(sheetName);
var ws = wb.Worksheets.Add(Before: wb.Worksheets[1]);
ws.Name = sheetName;
return(ws);
}
