Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook getTheme

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFWorkbook getTheme.

Prototype

public ThemesTable getTheme() 

Source Link

Document

Returns the Theme of current workbook.

Usage

From source file:com.vaadin.addon.spreadsheet.XSSFColorConverter.java

License:Open Source License

public XSSFColorConverter(XSSFWorkbook workbook) {
    this.workbook = workbook;
    workbook.getTheme();
}

---

From source file:de.escnet.ExcelTable.java

License:Open Source License

public ExcelTable(String excel, String sheetName) throws IOException {
    XSSFWorkbook wb = new XSSFWorkbook(excel);
    evaluator = wb.getCreationHelper().createFormulaEvaluator();
    theme = wb.getTheme();
    sheet = sheetName == null ? wb.getSheetAt(0) : wb.getSheet(sheetName);

    for (Iterator rowIt = sheet.rowIterator(); rowIt.hasNext();) {
        Row row = (Row) rowIt.next();/*ww w  .j  ava  2  s .  c  o m*/
        for (Iterator cellIt = row.cellIterator(); cellIt.hasNext();) {
            XSSFCell cell = (XSSFCell) cellIt.next();

            int rowIndex = cell.getRowIndex();
            rowMin = Math.min(rowMin, rowIndex);
            rowMax = Math.max(rowMax, rowIndex);

            int colIndex = cell.getColumnIndex();
            colMin = Math.min(colMin, colIndex);
            colMax = Math.max(colMax, colIndex);
        }
    }
}

---