CellFactory.java

/*
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 */

package net.rrm.ehour.ui.common.report.excel;

import net.rrm.ehour.report.reports.element.LockableDate;
import net.rrm.ehour.ui.common.util.WebUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFRichTextString;
import org.apache.wicket.model.IModel;

import java.util.Date;

/**
 * Created on Mar 25, 2009, 6:45:57 AM
 *
 * @author Thies Edeling (thies@te-con.nl)
 */
public class CellFactory {
    public static Cell createCell(Row row, int column, String value, ExcelWorkbook workbook) {
        return CellFactory.createCell(row, column, value, workbook, ExcelStyle.NORMAL_FONT);
    }

    public static Cell createCell(Row row, int column, IModel<String> valueModel, ExcelWorkbook workbook) {
        return CellFactory.createCell(row, column, valueModel, workbook, ExcelStyle.NORMAL_FONT);
    }

    public static Cell createCell(Row row, int column, ExcelWorkbook workbook, ExcelStyle excelStyle) {
        return createCell(row, column, "", workbook, excelStyle);
    }

    public static Cell createCell(Row row, int column, IModel<String> valueModel, ExcelWorkbook workbook, ExcelStyle excelStyle) {
        return createCell(row, column, WebUtils.getResourceModelString(valueModel), workbook, excelStyle);
    }

    public static Cell createCell(Row row, int column, Object value, ExcelWorkbook workbook, ExcelStyle excelStyle) {
        Cell cell = row.createCell(column);

        if (value instanceof Float) {
            cell.setCellValue((Float) value);
        } else if (value instanceof Number) {
            cell.setCellValue(((Number) value).doubleValue());
        } else if (value instanceof Date) {
            cell.setCellValue((Date)value);
        } else if (value instanceof LockableDate) {
            cell.setCellValue(((LockableDate) value).getDate());
        } else {
            cell.setCellValue(new XSSFRichTextString(value.toString()));
        }

        cell.setCellStyle(workbook.getCellStyle(excelStyle));

        return cell;
    }
}