com.neurosys.bi.reporting.writers

Class DefaultStyledExcelTabularDataWriter

java.lang.Object

com.neurosys.bi.reporting.writers.ExcelTabularDataWriter

com.neurosys.bi.reporting.writers.DefaultStyledExcelTabularDataWriter

All Implemented Interfaces:

ReportWriter, Writer

public class DefaultStyledExcelTabularDataWriter
extends ExcelTabularDataWriter

Some garnish !!

Author:

Arjun Dhar

Field Summary

Fields inherited from class com.neurosys.bi.reporting.writers.ExcelTabularDataWriter

baseReporters, dateStyle, fixedHeightPts, workbook, wrapStyle

Constructor Summary

Constructors

Constructor and Description
DefaultStyledExcelTabularDataWriter()

Method Summary

Modifier and Type	Method and Description
protected org.apache.poi.ss.usermodel.CellStyle	getCellStyle(int sheetIndex, int rowIndex, int colIndex, org.apache.poi.ss.usermodel.Cell cell)
void	init() Initialize the Export Writer
protected org.apache.poi.ss.usermodel.CellStyle	mergeCellStyles(org.apache.poi.ss.usermodel.CellStyle rowStyle, org.apache.poi.ss.usermodel.CellStyle cellStyle) CellStyle replaces another CellStyle.

Methods inherited from class com.neurosys.bi.reporting.writers.ExcelTabularDataWriter

createSheet, displayColumn, getBaseReporters, getDateFormat, getFixedHeightPts, getPageInfoForReport, getParamsForReport, getRowStyle, getSheet, getStartCol, getStartRow, setBaseReporters, setDateFormat, setFixedHeightPts, setStartCol, setStartRow, setValue, writeDataToStream, writeDataToWorkBook

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DefaultStyledExcelTabularDataWriter

public DefaultStyledExcelTabularDataWriter()

Method Detail

init

@PostConstruct
public void init()

Description copied from interface: ReportWriter

Initialize the Export Writer

Specified by:

init in interface ReportWriter

Overrides:

init in class ExcelTabularDataWriter

getCellStyle

protected final org.apache.poi.ss.usermodel.CellStyle getCellStyle(int sheetIndex,
                                                                   int rowIndex,
                                                                   int colIndex,
                                                                   org.apache.poi.ss.usermodel.Cell cell)

Overrides:

getCellStyle in class ExcelTabularDataWriter

mergeCellStyles

protected final org.apache.poi.ss.usermodel.CellStyle mergeCellStyles(org.apache.poi.ss.usermodel.CellStyle rowStyle,
                                                                      org.apache.poi.ss.usermodel.CellStyle cellStyle)
                                                               throws Exception

Description copied from class: ExcelTabularDataWriter

CellStyle replaces another CellStyle. Hence if there is a row style and a cell specific style they will overwrite one another. In particular the Cell style will overwrite. CellStyle properties are musch we may want to mix/merge instead of overwrite.

Overrides:

mergeCellStyles in class ExcelTabularDataWriter

Parameters:

rowStyle - as CellStyle

cellStyle - as CellStyle

Returns:

Throws:

Exception