com.dexcoder.commons.office.ExcelRow Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of dexcoder-commons Show documentation
The newest version!
package com.dexcoder.commons.office;

import java.util.ArrayList;
import java.util.List;

import com.dexcoder.commons.utils.StrUtils;

/**
 * sheet中的一行数据
 *
 * Created by liyd on 7/28/14.
 */
public class ExcelRow {

    /** 行中的列 */
    private List cells;

    public List getCells() {
        return cells;
    }

    public void setCells(List cells) {
        this.cells = cells;
    }

    public int getTotalCellsNum() {
        return cells.size();
    }

    public boolean hasCells() {
        return !cells.isEmpty();
    }

    public ExcelRow() {
        cells = new ArrayList();
    }

    public boolean isEmptyRow() {
        if (cells.isEmpty()) {
            return true;
        }
        for (ExcelCell excelCell : cells) {
            if (excelCell != null && excelCell.getValue() != null && StrUtils.isNotBlank(excelCell.getStringValue())) {
                return false;
            }
        }
        return true;
    }

    public void addCell(Object value) {
        ExcelCell excelCell = new ExcelCell(value);
        this.cells.add(excelCell);
    }

    public ExcelCell getFirstCell() {
        return cells.isEmpty() ? null : cells.iterator().next();
    }

    public ExcelCell getCell(int i) {
        return cells.isEmpty() ? null : cells.get(i);
    }

    public Object getCellValue(int i) {
        return cells.isEmpty() ? null : cells.get(i).getValue();
    }

    public String getCellStringValue(int i) {
        return cells.isEmpty() ? null : cells.get(i).getStringValue();
    }

    @Override
    public String toString() {

        if (cells == null) {
            return null;
        }
        StringBuilder sb = new StringBuilder();
        for (ExcelCell excelCell : cells) {
            sb.append(excelCell == null ? "null" : excelCell.toString()).append(" ");
        }
        return sb.toString();
    }
}