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); }