protected override void CompileSheet(ExcelWorksheet worksheet, DataTable table)
{
if (table.Rows.Count == 0)
{
return;
}
WorksheetDataHelper.FillData(worksheet, table, true);
FormatColumns(worksheet);
}
protected override void CompileSheet(ExcelWorksheet worksheet, DataTable table)
{
if (table.Rows.Count == 0)
{
return;
}
WorksheetDataHelper.FillData(worksheet, table, false);
ObtainLeftPaneWidth(worksheet);
FormatHeader(worksheet);
FormatRows(worksheet);
}
protected override void CompileSheet(ExcelWorksheet worksheet, DataTable table)
{
WorksheetDataHelper.FillData(worksheet, table, false);
var headerRow = worksheet.Cells[1, 1, 1, worksheet.Dimension.Columns];
headerRow.Style.Font.Size = 20;
headerRow.Style.Font.Bold = true;
var subHeaderRow = worksheet.Cells[2, 1, 2, worksheet.Dimension.Columns];
subHeaderRow.Style.Font.Size = 14;
subHeaderRow.Style.Font.Bold = true;
worksheet.Column(1).Width = 20;
}
protected override void CompileSheet(ExcelWorksheet worksheet, DataTable table)
{
if (table.Rows.Count == 0)
{
return;
}
WorksheetDataHelper.FillData(worksheet, table, false);
ObtainLeftPaneWidth(worksheet);
ObtainMeasuresCount(worksheet);
ObtainTotalColumns(worksheet);
FillHeaderData(worksheet);
RemoveTotalColumns(worksheet);
MergeHeaderCells(worksheet);
AppendCalculatedTotalColumns(worksheet);
WorksheetHelpers.FormatRows(worksheet, _headerRowsCount + 1, _leftPaneWidth);
WorksheetHelpers.FormatDataRows(worksheet, _headerRowsCount + 1, _totalColumnIndexes, _leftPaneWidth + 1);
WorksheetHelpers.FormatHeader(worksheet, _headerRowsCount, _totalColumnIndexes);
FormatSummaryRows(worksheet);
}