/**************************************************************************/
private void BuildWorksheetKeywordTerms(
MacroscopeJobMaster JobMaster,
XLWorkbook wb,
string WorksheetLabel,
Dictionary <string, int> DicTerms
)
{
var ws = wb.Worksheets.Add(WorksheetLabel);
decimal TermTotal = DicTerms.Count;
decimal TermCount = 0;
int iRow = 1;
int iCol = 1;
int iColMax = 1;
MacroscopeDocumentCollection DocCollection = JobMaster.GetDocCollection();
MacroscopeAllowedHosts AllowedHosts = JobMaster.GetAllowedHosts();
{
ws.Cell(iRow, iCol).Value = "Occurrences";
iCol++;
ws.Cell(iRow, iCol).Value = "Term";
iCol++;
ws.Cell(iRow, iCol).Value = "URL";
}
iColMax = iCol;
iRow++;
foreach (string Term in DicTerms.Keys)
{
MacroscopeDocumentList DocumentList = DocCollection.GetDeepKeywordAnalysDocumentList(Term);
decimal DocTotal = ( decimal )DocumentList.CountDocuments();
decimal DocCount = 0;
TermCount++;
if (TermTotal > 0)
{
this.ProgressForm.UpdatePercentages(
Title: null,
Message: null,
MajorPercentage: -1,
ProgressLabelMajor: null,
MinorPercentage: (( decimal )100 / TermTotal) * TermCount,
ProgressLabelMinor: "Keywords Processed",
SubMinorPercentage: -1,
ProgressLabelSubMinor: null
);
}
foreach (MacroscopeDocument msDoc in DocumentList.IterateDocuments())
{
DocCount++;
if (DocTotal > 0)
{
this.ProgressForm.UpdatePercentages(
Title: null,
Message: null,
MajorPercentage: -1,
ProgressLabelMajor: null,
MinorPercentage: -1,
ProgressLabelMinor: null,
SubMinorPercentage: (( decimal )100 / DocTotal) * DocCount,
ProgressLabelSubMinor: "Documents Processed"
);
}
iCol = 1;
this.InsertAndFormatContentCell(ws, iRow, iCol, this.FormatIfMissing(DicTerms[Term].ToString()));
iCol++;
this.InsertAndFormatContentCell(ws, iRow, iCol, this.FormatIfMissing(Term));
iCol++;
this.InsertAndFormatUrlCell(ws, iRow, iCol, msDoc.GetUrl());
iRow++;
}
}
{
var rangeData = ws.Range(1, 1, iRow - 1, iColMax);
var excelTable = rangeData.CreateTable();
}
}
