/**************************************************************************/
private void SaveOutputFile(XLWorkbook Workbook, string OutputFilename)
{
try
{
Workbook.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook wb = new XLWorkbook();
this.BuildWorksheetPageObservations(JobMaster, wb, "Observations");
try
{
wb.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook Workbook = new XLWorkbook();
this.BuildWorksheetBlockedByRobotsInternal(JobMaster, Workbook, "Internal URLs Blocked by Robots");
this.BuildWorksheetBlockedByRobotsExternal(JobMaster, Workbook, "External URLs Blocked by Robots");
try
{
Workbook.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook wb = new XLWorkbook();
this.BuildWorksheetEmailAddresses(JobMaster, wb, "Email Addresses");
this.BuildWorksheetTelephoneNumbers(JobMaster, wb, "Telephone Numbers");
try
{
wb.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook wb = new XLWorkbook();
this.BuildWorksheetPageLinks(JobMaster, wb, "Links");
this.BuildWorksheetPageHyperlinks(JobMaster, wb, "Hyperlinks");
this.BuildWorksheetPageUriAnalysis(JobMaster, wb, "URI Analysis");
this.BuildWorksheetPageOrphanedPages(JobMaster, wb, "Orphaned Pages");
try
{
wb.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook wb = new XLWorkbook();
this.BuildWorksheetPageCombinedTextMetadata(JobMaster, wb, "Combined Text Metadata");
this.BuildWorksheetPageTitles(JobMaster, wb, "Page Titles");
this.BuildWorksheetPageDescriptions(JobMaster, wb, "Page Descriptions");
this.BuildWorksheetPageKeywords(JobMaster, wb, "Page Keywords");
this.BuildWorksheetPageAuthors(JobMaster, wb, "Authors");
try
{
wb.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook wb = new XLWorkbook();
this.BuildWorksheetMissingLanguageSpecifier(JobMaster, wb, "Missing Language Specifier");
this.BuildWorksheetHrefLangMatrix(JobMaster, wb, "HrefLang Matrix");
this.BuildWorksheetHrefLangMatrixUnspecified(JobMaster, wb, "HrefLang Matrix Unspecified");
try
{
wb.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook Workbook = new XLWorkbook();
MacroscopeDocumentList DocumentsNotInSitemaps = JobMaster.GetDocCollection().GetDocumentsNotInSitemaps();
MacroscopeDocumentList DocumentsInSitemaps = JobMaster.GetDocCollection().GetDocumentsInSitemaps();
this.BuildWorksheetSitemapXmlErrors(JobMaster, Workbook, "Sitemap XML Errors");
this.BuildWorksheetSitemapsAudit(JobMaster, Workbook, "Sitemaps Audit - Missing", DocumentsNotInSitemaps, false);
this.BuildWorksheetSitemapsAudit(JobMaster, Workbook, "Sitemaps Audit - Present", DocumentsInSitemaps, true);
try
{
Workbook.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(
MacroscopeJobMaster JobMaster,
string OutputFilename
)
{
XLWorkbook Workbook = new XLWorkbook();
this.BuildWorksheetCssSelectors(JobMaster, Workbook, "CSS Selectors");
this.BuildWorksheetRegularExpressions(JobMaster, Workbook, "Regular Expressions");
this.BuildWorksheetXpaths(JobMaster, Workbook, "XPaths");
try
{
Workbook.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook wb = new XLWorkbook();
DebugMsg(string.Format("EXCEL OutputFilename: {0}", OutputFilename));
lock (this.TargetListViewLock)
{
this.BuildWorksheetListView(JobMaster, wb, WorksheetName);
}
try
{
wb.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook wb = new XLWorkbook();
const decimal MajorPercentageDivider = 4;
for (int i = 0; i <= 3; i++)
{
this.ProgressForm.UpdatePercentages(
Title: "Processing Keywords",
Message: "Processing keyword terms collection:",
MajorPercentage: (( decimal )100 / MajorPercentageDivider) * ( decimal )i + 1,
ProgressLabelMajor: "",
MinorPercentage: 0,
ProgressLabelMinor: "",
SubMinorPercentage: 0,
ProgressLabelSubMinor: ""
);
Dictionary <string, int> DicTerms = JobMaster.GetDocCollection().GetDeepKeywordAnalysisAsDictonary(Words: i + 1);
this.BuildWorksheetKeywordTerms(JobMaster, wb, string.Format("{0} Word Term", i + 1), DicTerms);
}
try
{
wb.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
/**************************************************************************/
public void WriteXslx(MacroscopeJobMaster JobMaster, string OutputFilename)
{
XLWorkbook wb = new XLWorkbook();
decimal MajorPercentageDivider = 3;
if (MacroscopePreferencesManager.GetEnableLevenshteinDeduplication())
{
MajorPercentageDivider = 4;
}
if (!this.ProgressForm.Cancelled())
{
this.ProgressForm.UpdatePercentages(
Title: "Processing Titles",
Message: "Identifying duplicate titles in collection:",
MajorPercentage: (( decimal )100 / MajorPercentageDivider) * ( decimal )1,
ProgressLabelMajor: "Documents Processed",
MinorPercentage: 0,
ProgressLabelMinor: "",
SubMinorPercentage: 0,
ProgressLabelSubMinor: ""
);
this.BuildWorksheetPageDuplicateTitles(JobMaster, wb, "Duplicate Titles");
}
if (!this.ProgressForm.Cancelled())
{
this.ProgressForm.UpdatePercentages(
Title: "Processing Checksums",
Message: "Identifying duplicate checksums in collection:",
MajorPercentage: (( decimal )100 / MajorPercentageDivider) * ( decimal )2,
ProgressLabelMajor: "Documents Processed",
MinorPercentage: 0,
ProgressLabelMinor: "",
SubMinorPercentage: 0,
ProgressLabelSubMinor: ""
);
this.BuildWorksheetPageDuplicateChecksums(JobMaster, wb, "Duplicate Checksums");
}
if (!this.ProgressForm.Cancelled())
{
this.ProgressForm.UpdatePercentages(
Title: "Processing ETags",
Message: "Identifying duplicate ETags in collection:",
MajorPercentage: (( decimal )100 / MajorPercentageDivider) * ( decimal )3,
ProgressLabelMajor: "Documents Processed",
MinorPercentage: 0,
ProgressLabelMinor: "",
SubMinorPercentage: 0,
ProgressLabelSubMinor: ""
);
this.BuildWorksheetPageDuplicateEtags(JobMaster, wb, "Duplicate ETags");
}
if (!this.ProgressForm.Cancelled())
{
if (MacroscopePreferencesManager.GetEnableLevenshteinDeduplication())
{
this.ProgressForm.UpdatePercentages(
Title: "Applying Levenshtein Distance",
Message: "Identifying duplicate documents via Levenshtein Distance in collection:",
MajorPercentage: (( decimal )100 / MajorPercentageDivider) * ( decimal )4,
ProgressLabelMajor: "Documents Processed: 0",
MinorPercentage: 0,
ProgressLabelMinor: "",
SubMinorPercentage: 0,
ProgressLabelSubMinor: ""
);
this.BuildWorksheetPageDuplicatePages(JobMaster, wb, "Duplicate Content");
}
}
if (!this.ProgressForm.Cancelled())
{
try
{
wb.SaveAs(OutputFilename);
}
catch (IOException)
{
MacroscopeSaveExcelFileException CannotSaveExcelFileException;
CannotSaveExcelFileException = new MacroscopeSaveExcelFileException(
string.Format("Cannot write to Excel file at {0}", OutputFilename)
);
throw CannotSaveExcelFileException;
}
}
}