com.whaleal.icefrog.poi.excel.cell.NullCell Maven / Gradle / Ivy

Go to download
package com.whaleal.icefrog.poi.excel.cell;

import org.apache.poi.ss.formula.FormulaParseException;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellAddress;
import org.apache.poi.ss.util.CellRangeAddress;

import java.time.LocalDateTime;
import java.util.Calendar;
import java.util.Date;

/**
 * 当单元格不存在时使用此对象表示，得到的值都为null,此对象只用于标注单元格所在位置信息。
 *
 * @author Looly
 * @author wh
 * @since 1.0.0
 */
public class NullCell implements Cell {

    private final Row row;
    private final int columnIndex;

    /**
     * 构造
     *
     * @param row         行
     * @param columnIndex 列号，从0开始
     */
    public NullCell( Row row, int columnIndex ) {
        this.row = row;
        this.columnIndex = columnIndex;
    }

    @Override
    public int getColumnIndex() {
        return this.columnIndex;
    }

    @Override
    public int getRowIndex() {
        return getRow().getRowNum();
    }

    @Override
    public Sheet getSheet() {
        return getRow().getSheet();
    }

    @Override
    public Row getRow() {
        return this.row;
    }

    @Override
    public void setBlank() {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public CellType getCellType() {
        return null;
    }

    @Override
    public void setCellType( CellType cellType ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    public CellType getCellTypeEnum() {
        return null;
    }

    @Override
    public CellType getCachedFormulaResultType() {
        return null;
    }

    public CellType getCachedFormulaResultTypeEnum() {
        return null;
    }

    @Override
    public void setCellValue( double value ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void setCellValue( Date value ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void setCellValue( LocalDateTime value ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void setCellValue( Calendar value ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void setCellValue( RichTextString value ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void setCellValue( String value ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void removeFormula() throws IllegalStateException {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public String getCellFormula() {
        return null;
    }

    @Override
    public void setCellFormula( String formula ) throws FormulaParseException, IllegalStateException {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public double getNumericCellValue() {
        throw new UnsupportedOperationException("Cell value is null!");
    }

    @Override
    public Date getDateCellValue() {
        return null;
    }

    @Override
    public LocalDateTime getLocalDateTimeCellValue() {
        return null;
    }

    @Override
    public RichTextString getRichStringCellValue() {
        return null;
    }

    @Override
    public String getStringCellValue() {
        return null;
    }

    @Override
    public void setCellValue( boolean value ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void setCellErrorValue( byte value ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public boolean getBooleanCellValue() {
        throw new UnsupportedOperationException("Cell value is null!");
    }

    @Override
    public byte getErrorCellValue() {
        throw new UnsupportedOperationException("Cell value is null!");
    }

    @Override
    public CellStyle getCellStyle() {
        return null;
    }

    @Override
    public void setCellStyle( CellStyle style ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void setAsActiveCell() {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public CellAddress getAddress() {
        return null;
    }

    @Override
    public Comment getCellComment() {
        return null;
    }

    @Override
    public void setCellComment( Comment comment ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void removeCellComment() {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public Hyperlink getHyperlink() {
        return null;
    }

    @Override
    public void setHyperlink( Hyperlink link ) {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public void removeHyperlink() {
        throw new UnsupportedOperationException("Can not set any thing to null cell!");
    }

    @Override
    public CellRangeAddress getArrayFormulaRange() {
        return null;
    }

    @Override
    public boolean isPartOfArrayFormulaGroup() {
        throw new UnsupportedOperationException("Cell value is null!");
    }
}