org.jxls.transform.poi.PoiSheetData Maven / Gradle / Ivy

Go to download

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

Apache POI based Transformer implementation for Jxls library

There is a newer version: 3.0.0

package org.jxls.transform.poi;

import org.jxls.common.SheetData;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;

import java.util.ArrayList;
import java.util.List;

/**
 * Sheet data wrapper for POI sheet
 * @author Leonid Vysochyn
 *         Date: 2/1/12
 */
public class PoiSheetData extends SheetData {
    List mergedRegions = new ArrayList();
    Sheet sheet;


    public static PoiSheetData createSheetData(Sheet sheet, PoiTransformer transformer){
        PoiSheetData sheetData = new PoiSheetData();
        sheetData.setTransformer(transformer);
        sheetData.sheet = sheet;
        sheetData.sheetName = sheet.getSheetName();
        sheetData.columnWidth = new int[256];
        for(int i = 0; i < 256; i++){
            sheetData.columnWidth[i] = sheet.getColumnWidth(i);
        }
        int numberOfRows = sheet.getLastRowNum() + 1;
        for(int i = 0; i < numberOfRows; i++){
            sheetData.rowDataList.add(PoiRowData.createRowData(sheet.getRow(i), transformer));
        }
        for(int i = 0; i < sheet.getNumMergedRegions(); i++){
            CellRangeAddress region = sheet.getMergedRegion(i);
            sheetData.mergedRegions.add(region);
        }
        return sheetData;
    }



    public List getMergedRegions() {
        return mergedRegions;
    }

    public Sheet getSheet() {
        return sheet;
    }
}