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

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ujmp-poi Show documentation

Plugin to enable import and export for Excel files using Apache POI

The newest version!

/*
 * 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.File;
import java.io.IOException;
import java.io.InputStream;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.ujmp.core.objectmatrix.DenseObjectMatrix2D;

public class MatrixXLSXImporter extends AbstractMatrixExcelImporter {

	public DenseObjectMatrix2D importFromXLSX(final String filename, final int sheetNumber)
			throws InvalidFormatException, IOException {
		return importFromXLSX(new File(filename), sheetNumber);
	}

	public DenseObjectMatrix2D importFromXLSX(final File file, final int sheetNumber) throws InvalidFormatException,
			IOException {
		final OPCPackage pkg = OPCPackage.open(file);
		final XSSFWorkbook workbook = new XSSFWorkbook(pkg);
		final DenseObjectMatrix2D matrix = importFromWorkbook(workbook, sheetNumber);
		pkg.close();
		return matrix;
	}

	public DenseObjectMatrix2D importFromXLSX(final InputStream inputStream, final int sheetNumber)
			throws InvalidFormatException, IOException {
		final OPCPackage pkg = OPCPackage.open(inputStream);
		final XSSFWorkbook workbook = new XSSFWorkbook(pkg);
		final DenseObjectMatrix2D matrix = importFromWorkbook(workbook, sheetNumber);
		pkg.close();
		return matrix;
	}
}