eu.esdihumboldt.hale.io.xls.AnalyseXLSSchemaTable.java Source code

Introduction

Here is the source code for eu.esdihumboldt.hale.io.xls.AnalyseXLSSchemaTable.java

Source

/*
 * Copyright (c) 2013 Data Harmonisation Panel
 * 
 * All rights reserved. This program and the accompanying materials are made
 * available under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation, either version 3 of the License,
 * or (at your option) any later version.
 * 
 * You should have received a copy of the GNU Lesser General Public License
 * along with this distribution. If not, see <http://www.gnu.org/licenses/>.
 * 
 * Contributors:
 *     Data Harmonisation Panel <http://www.dhpanel.eu>
 */

package eu.esdihumboldt.hale.io.xls;

import java.net.URI;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.poi.ss.usermodel.Row;

/**
 * Analyse xls/xlsx schema files
 * 
 * @author Patrick Lieb
 */
public class AnalyseXLSSchemaTable extends AbstractAnalyseTable {

    private final List<String> header;

    private final Map<Integer, List<String>> rows;

    /**
     * Default constructor
     * 
     * @param location the location of the Excel file
     * @param sheetNum number of the sheet in Excel file (0-based)
     * 
     * @throws Exception thrown if the analysis fails
     */
    public AnalyseXLSSchemaTable(URI location, int sheetNum) throws Exception {

        header = new ArrayList<String>();
        rows = new HashMap<Integer, List<String>>();

        analyse(location, sheetNum);
    }

    /**
     * @see eu.esdihumboldt.hale.io.xls.AbstractAnalyseTable#headerCell(int,
     *      java.lang.String)
     */
    @Override
    protected void headerCell(int num, String text) {
        if (num == header.size())
            header.add(text);
        header.set(num, text);
    }

    /**
     * @see eu.esdihumboldt.hale.io.xls.AbstractAnalyseTable#analyseRow(int,
     *      org.apache.poi.ss.usermodel.Row)
     */
    @Override
    protected void analyseRow(int num, Row row) {
        List<String> rowContent = new ArrayList<String>();
        for (int i = 0; i < row.getLastCellNum(); i++) {
            rowContent.add(extractText(row.getCell(i)));
        }
        rows.put(num, rowContent);
    }

    /**
     * @return the header
     */
    public List<String> getHeader() {
        return header;
    }

    /**
     * @return the second row
     */
    public List<String> getSecondRow() {
        return rows.get(1);
    }

    /**
     * @return a map of all rows with row number as keys
     */
    public Collection<List<String>> getRows() {
        return rows.values();
    }

}