org.jxls.transform.jexcel.JexcelSheetData Maven / Gradle / Ivy

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

Jexcel API Transformer implementation for Jxls library

There is a newer version: 1.0.9

package org.jxls.transform.jexcel;

import org.jxls.common.SheetData;
import jxl.Range;
import jxl.Sheet;
import org.jxls.transform.Transformer;

/**
 * @author Leonid Vysochyn
 */
public class JexcelSheetData extends SheetData {
    Sheet sheet;
    Range[] mergedCells;

    public static JexcelSheetData createSheetData(Sheet sheet, JexcelTransformer transformer){
        JexcelSheetData sheetData = new JexcelSheetData();
        sheetData.setTransformer(transformer);
        sheetData.sheet = sheet;
        sheetData.sheetName = sheet.getName();
        sheetData.columnWidth = new int[256];
        for(int i = 0; i < 256; i++){
            sheetData.columnWidth[i] = sheet.getColumnView(i).getSize();
        }
        int numberOfRows = sheet.getRows();
        for(int i = 0; i < numberOfRows; i++){
            sheetData.rowDataList.add(JexcelRowData.createRowData(sheet, i, transformer));
        }
        sheetData.mergedCells = sheet.getMergedCells();
        return sheetData;
    }

    public Sheet getSheet() {
        return sheet;
    }

    public Range[] getMergedCells(){
        return mergedCells;
    }
}