org.ujmp.poi.AbstractMatrixExcelExporter Maven / Gradle / Ivy

Go to download
/*
 * Copyright (C) 2008-2015 by Holger Arndt
 *
 * This file is part of the Universal Java Matrix Package (UJMP).
 * See the NOTICE file distributed with this work for additional
 * information regarding copyright ownership and licensing.
 *
 * UJMP is free software; you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * UJMP 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 Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with UJMP; if not, write to the
 * Free Software Foundation, Inc., 51 Franklin St, Fifth Floor,
 * Boston, MA  02110-1301  USA
 */

package org.ujmp.poi;

import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Date;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.ujmp.core.Matrix;
import org.ujmp.core.util.StringUtil;

public abstract class AbstractMatrixExcelExporter {

	public void exportToExcelFile(final Workbook workbook, final Matrix matrix, final File file, String sheetName)
			throws IOException {
		final Sheet sheet = workbook.createSheet(sheetName);

		final int rowCount = (int) matrix.getRowCount();
		final int columnCount = (int) matrix.getColumnCount();
		for (int r = 0; r < rowCount; r++) {
			Row row = sheet.createRow(r);
			for (int c = 0; c < columnCount; c++) {
				Object o = matrix.getAsObject(r, c);
				if (o != null) {
					Cell cell = row.createCell(c);
					if (o instanceof Double) {
						cell.setCellValue((Double) o);
					} else if (o instanceof String) {
						cell.setCellValue((String) o);
					} else if (o instanceof Date) {
						cell.setCellValue((Date) o);
					} else if (o instanceof Boolean) {
						cell.setCellValue((Boolean) o);
					} else {
						cell.setCellValue(StringUtil.convert(o));
					}
				}
			}
		}

		final FileOutputStream fileOutputStream = new FileOutputStream(file);
		final BufferedOutputStream bufferedOutputStream = new BufferedOutputStream(fileOutputStream);
		workbook.write(fileOutputStream);
		bufferedOutputStream.close();
		fileOutputStream.close();
	}

}