Examples with XlsxReadSheetHolder com.alibaba.excel.read.metadata.holder.xlsx.XlsxReadSheetHolder used on opensource projects

Example 6 with XlsxReadSheetHolder

use of com.alibaba.excel.read.metadata.holder.xlsx.XlsxReadSheetHolder in project easyexcel by alibaba.

the class CellTagHandler method startElement.

@Override
public void startElement(XlsxReadContext xlsxReadContext, String name, Attributes attributes) {
    XlsxReadSheetHolder xlsxReadSheetHolder = xlsxReadContext.xlsxReadSheetHolder();
    xlsxReadSheetHolder.setColumnIndex(PositionUtils.getCol(attributes.getValue(ExcelXmlConstants.ATTRIBUTE_R), xlsxReadSheetHolder.getColumnIndex()));
    // t="s" ,it means String
    // t="str" ,it means String,but does not need to be read in the 'sharedStrings.xml'
    // t="inlineStr" ,it means String,but does not need to be read in the 'sharedStrings.xml'
    // t="b" ,it means Boolean
    // t="e" ,it means Error
    // t="n" ,it means Number
    // t is null ,it means Empty or Number
    CellDataTypeEnum type = CellDataTypeEnum.buildFromCellType(attributes.getValue(ExcelXmlConstants.ATTRIBUTE_T));
    xlsxReadSheetHolder.setTempCellData(new ReadCellData<>(type));
    xlsxReadSheetHolder.setTempData(new StringBuilder());
    // Put in data transformation information
    String dateFormatIndex = attributes.getValue(ExcelXmlConstants.ATTRIBUTE_S);
    int dateFormatIndexInteger;
    if (StringUtils.isEmpty(dateFormatIndex)) {
        dateFormatIndexInteger = DEFAULT_FORMAT_INDEX;
    } else {
        dateFormatIndexInteger = Integer.parseInt(dateFormatIndex);
    }
    xlsxReadSheetHolder.getTempCellData().setDataFormatData(xlsxReadContext.xlsxReadWorkbookHolder().dataFormatData(dateFormatIndexInteger));
}

Example 7 with XlsxReadSheetHolder

use of com.alibaba.excel.read.metadata.holder.xlsx.XlsxReadSheetHolder in project easyexcel by alibaba.

the class RowTagHandler method startElement.

@Override
public void startElement(XlsxReadContext xlsxReadContext, String name, Attributes attributes) {
    XlsxReadSheetHolder xlsxReadSheetHolder = xlsxReadContext.xlsxReadSheetHolder();
    int rowIndex = PositionUtils.getRowByRowTagt(attributes.getValue(ExcelXmlConstants.ATTRIBUTE_R), xlsxReadSheetHolder.getRowIndex());
    Integer lastRowIndex = xlsxReadContext.readSheetHolder().getRowIndex();
    while (lastRowIndex + 1 < rowIndex) {
        xlsxReadContext.readRowHolder(new ReadRowHolder(lastRowIndex + 1, RowTypeEnum.EMPTY, xlsxReadSheetHolder.getGlobalConfiguration(), new LinkedHashMap<Integer, Cell>()));
        xlsxReadContext.analysisEventProcessor().endRow(xlsxReadContext);
        xlsxReadSheetHolder.setColumnIndex(null);
        xlsxReadSheetHolder.setCellMap(new LinkedHashMap<Integer, Cell>());
        lastRowIndex++;
    }
    xlsxReadSheetHolder.setRowIndex(rowIndex);
}