bad.robot.excel.matchers.StubCell.java Source code

Introduction

Here is the source code for bad.robot.excel.matchers.StubCell.java

Source

/*
 * Copyright (c) 2012-2013, bad robot (london) ltd.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package bad.robot.excel.matchers;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import java.util.Date;

import static org.apache.poi.ss.usermodel.Cell.*;

class StubCell {

    static Cell createBlankCell(int row, int column) {
        return create(row, column, CELL_TYPE_BLANK);
    }

    static Cell createCell(int row, int column, Boolean aBoolean) {
        Cell cell = create(row, column, CELL_TYPE_BOOLEAN);
        cell.setCellValue(aBoolean);
        return cell;
    }

    static Cell createCell(Boolean aBoolean) {
        return createCell(0, 0, aBoolean);
    }

    static Cell createCell(int row, int column, Byte value) {
        Cell cell = create(row, column, CELL_TYPE_ERROR);
        cell.setCellErrorValue(value);
        return cell;
    }

    static Cell createFormulaCell(int row, int column, String formula) {
        Cell cell = create(row, column, CELL_TYPE_FORMULA);
        cell.setCellFormula(formula);
        return cell;
    }

    static Cell createCell(int row, int column, Double aDouble) {
        Cell cell = create(row, column, CELL_TYPE_NUMERIC);
        cell.setCellValue(aDouble);
        return cell;
    }

    static Cell createCell(Double aDouble) {
        return createCell(0, 0, aDouble);
    }

    static Cell createCell(int row, int column, Date date) {
        Workbook workbook = new HSSFWorkbook();
        Sheet sheet = workbook.createSheet();
        Cell cell = sheet.createRow(row).createCell(column, CELL_TYPE_NUMERIC);
        cell.setCellValue(date);
        CellStyle style = workbook.createCellStyle();
        style.setDataFormat(workbook.getCreationHelper().createDataFormat().getFormat("m/d/yy h:mm"));
        cell.setCellStyle(style);
        return cell;
    }

    static Cell createCell(int row, int column, String value) {
        Cell cell = create(row, column, CELL_TYPE_STRING);
        cell.setCellValue(value);
        return cell;
    }

    static Cell createCell(String value) {
        return createCell(0, 0, value);
    }

    private static Cell create(int row, int column, int type) {
        Workbook workbook = new HSSFWorkbook();
        Sheet sheet = workbook.createSheet();
        Cell cell = sheet.createRow(row).createCell(column, type);
        return cell;
    }

}