private int calculateNonEmptyCells(SpreadsheetHeaderDefinition headerDefinition) { int fromRow = 0; int toRow = cellsHeaderExtractor.getHeight(); int fromColumn = 0; int toColumn = cellsHeaderExtractor.getWidth(); if (headerDefinition.isRow()) { fromRow = headerDefinition.getRow(); toRow = fromRow + 1; } else { fromColumn = headerDefinition.getColumn(); toColumn = fromColumn + 1; } int nonEmptyCellsCount = 0; for (int columnIndex = fromColumn; columnIndex < toColumn; columnIndex++) { for (int rowIndex = fromRow; rowIndex < toRow; rowIndex++) { ILogicalTable cell = LogicalTableHelper.mergeBounds(cellsHeaderExtractor.getRowNamesTable().getRow(rowIndex), cellsHeaderExtractor.getColumnNamesTable().getColumn(columnIndex)); String value = cell.getSource().getCell(0, 0).getStringValue(); if (value != null && value.trim().length() > 0) { nonEmptyCellsCount += 1; } } } return nonEmptyCellsCount; }
data = LogicalTableHelper.mergeBounds(leftRows, colTable);
Map<Integer, SpreadsheetHeaderDefinition> rowHeaders = componentsBuilder.getRowHeaders(); ILogicalTable cell = LogicalTableHelper.mergeBounds( componentsBuilder.getCellsHeadersExtractor().getRowNamesTable().getRow(rowIndex), componentsBuilder.getCellsHeadersExtractor().getColumnNamesTable().getColumn(columnIndex));
ILogicalTable cell = LogicalTableHelper.mergeBounds( componentsBuilder.getCellsHeadersExtractor().getRowNamesTable().getRow(rowIndex), componentsBuilder.getCellsHeadersExtractor().getColumnNamesTable().getColumn(columnIndex));