jdbreport.model.io.xls.poi.Excel2007Writer.java Source code

Introduction

Here is the source code for jdbreport.model.io.xls.poi.Excel2007Writer.java

Source

/*
 * Excel2007Writer.java
 *
 * JDBReport Generator
 * 
 * Copyright (C) 2009-2014 Andrey Kholmanskih
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 */
package jdbreport.model.io.xls.poi;

import java.awt.Color;

import jdbreport.model.Border;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFColor;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * @version 1.0 15.08.2009
 * @author Andrey Kholmanskih
 * 
 */
public class Excel2007Writer extends Excel2003Writer {

    protected Workbook createWorkbook() {
        return new XSSFWorkbook();
    }

    protected CellStyle createStyle(jdbreport.model.CellStyle style, Workbook wb) {

        XSSFCellStyle newStyle = (XSSFCellStyle) wb.createCellStyle();
        newStyle.setAlignment(convertHorizontalAlign(style.getHorizontalAlignment()));
        newStyle.setVerticalAlignment(convertVerticalAlign(style.getVerticalAlignment()));

        Border border = style.getBorders(Border.LINE_BOTTOM);
        if (border != null) {
            newStyle.setBorderBottom(getBorder(border));
            newStyle.setBottomBorderColor(new XSSFColor(border.getColor()));
        }
        border = style.getBorders(Border.LINE_TOP);
        if (border != null) {
            newStyle.setBorderTop(getBorder(border));
            newStyle.setTopBorderColor(new XSSFColor(border.getColor()));
        }
        border = style.getBorders(Border.LINE_LEFT);
        if (border != null) {
            newStyle.setBorderLeft(getBorder(border));
            newStyle.setLeftBorderColor(new XSSFColor(border.getColor()));
        }
        border = style.getBorders(Border.LINE_RIGHT);
        if (border != null) {
            newStyle.setBorderRight(getBorder(border));
            newStyle.setRightBorderColor(new XSSFColor(border.getColor()));
        }

        Font font = wb.createFont();
        font.setFontName(style.getFamily());
        if (style.isBold()) {
            font.setBold(true);
        }
        font.setItalic(style.isItalic());
        if (style.isUnderline()) {
            font.setUnderline(Font.U_SINGLE);
        }
        if (style.isStrikethrough()) {
            font.setStrikeout(true);
        }
        font.setFontHeightInPoints((short) style.getSize());
        if (style.getForegroundColor() != null && !style.getForegroundColor().equals(Color.black)) {
            font.setColor(colorToIndex(wb, style.getForegroundColor()));
        }

        newStyle.setFont(font);

        if (style.getBackground() != null && !style.getBackground().equals(Color.white)) {
            newStyle.setFillForegroundColor(new XSSFColor(style.getBackground()));
            newStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        }

        if (style.getAngle() != 0) {
            int angle = style.getAngle();
            if (angle > 90 && angle <= 180) {
                angle = 90;
            } else if (angle > 180 && angle <= 270) {
                angle = -90;
            } else if (angle > 270) {
                angle = -(360 - angle);
            }
            newStyle.setRotation((short) angle);
        }

        newStyle.setWrapText(style.isWrapLine());

        return newStyle;
    }

    protected short colorToIndex(Workbook wb, Color color) {
        if (color == null) {
            return 0;
        }
        if (Color.black.equals(color)) {
            return IndexedColors.BLACK.getIndex();
        }
        if (Color.white.equals(color)) {
            return IndexedColors.WHITE.getIndex();
        }
        if (Color.blue.equals(color) || Color.blue.darker().equals(color) || Color.blue.brighter().equals(color)) {
            return IndexedColors.BLUE.getIndex();
        }
        if (Color.red.equals(color) || Color.red.darker().equals(color) || Color.red.brighter().equals(color)) {
            return IndexedColors.RED.getIndex();
        }
        if (Color.LIGHT_GRAY.equals(color)) {
            return IndexedColors.GREY_25_PERCENT.getIndex();
        }
        if (Color.GRAY.equals(color)) {
            return IndexedColors.GREY_50_PERCENT.getIndex();
        }
        if (Color.DARK_GRAY.equals(color)) {
            return IndexedColors.GREY_80_PERCENT.getIndex();
        }
        if (Color.green.equals(color) || Color.green.brighter().equals(color)
                || Color.green.darker().equals(color)) {
            return IndexedColors.GREEN.getIndex();
        }
        if (Color.magenta.equals(color) || Color.magenta.darker().equals(color)
                || Color.magenta.brighter().equals(color)) {
            return IndexedColors.MAROON.getIndex();
        }
        if (Color.orange.equals(color) || Color.orange.darker().equals(color)
                || Color.orange.brighter().equals(color)) {
            return IndexedColors.ORANGE.getIndex();
        }
        if (Color.pink.equals(color) || Color.pink.darker().equals(color) || Color.pink.brighter().equals(color)) {
            return IndexedColors.PINK.getIndex();
        }
        if (Color.yellow.equals(color) || Color.yellow.darker().equals(color)
                || Color.yellow.brighter().equals(color)) {
            return IndexedColors.YELLOW.getIndex();
        }

        XSSFColor xssfColor = new XSSFColor(color);
        return xssfColor.getIndexed();
    }

}