Examples with AnalysisCell com.alibaba.excel.write.metadata.fill.AnalysisCell used on opensource projects

Example 6 with AnalysisCell

use of com.alibaba.excel.write.metadata.fill.AnalysisCell in project easyexcel by alibaba.

the class ExcelWriteFillExecutor method initAnalysisCell.

private AnalysisCell initAnalysisCell(Integer rowIndex, Integer columnIndex) {
    AnalysisCell analysisCell = new AnalysisCell();
    analysisCell.setRowIndex(rowIndex);
    analysisCell.setColumnIndex(columnIndex);
    analysisCell.setOnlyOneVariable(Boolean.TRUE);
    List<String> variableList = ListUtils.newArrayList();
    analysisCell.setVariableList(variableList);
    List<String> prepareDataList = ListUtils.newArrayList();
    analysisCell.setPrepareDataList(prepareDataList);
    analysisCell.setCellType(WriteTemplateAnalysisCellTypeEnum.COMMON);
    analysisCell.setFirstRow(Boolean.FALSE);
    return analysisCell;
}

Example 7 with AnalysisCell

use of com.alibaba.excel.write.metadata.fill.AnalysisCell in project easyexcel by alibaba.

the class ExcelWriteFillExecutor method readTemplateData.

private List<AnalysisCell> readTemplateData(Map<UniqueDataFlagKey, List<AnalysisCell>> analysisCache) {
    List<AnalysisCell> analysisCellList = analysisCache.get(currentUniqueDataFlag);
    if (analysisCellList != null) {
        return analysisCellList;
    }
    Sheet sheet = writeContext.writeSheetHolder().getCachedSheet();
    Map<UniqueDataFlagKey, Set<Integer>> firstRowCache = MapUtils.newHashMapWithExpectedSize(8);
    for (int i = 0; i <= sheet.getLastRowNum(); i++) {
        Row row = sheet.getRow(i);
        if (row == null) {
            continue;
        }
        for (int j = 0; j < row.getLastCellNum(); j++) {
            Cell cell = row.getCell(j);
            if (cell == null) {
                continue;
            }
            String preparedData = prepareData(cell, i, j, firstRowCache);
            // Prevent empty data from not being replaced
            if (preparedData != null) {
                cell.setCellValue(preparedData);
            }
        }
    }
    return analysisCache.get(currentUniqueDataFlag);
}