Package org.primefaces.extensions.component.exporter

Class ExcelExporter

java.lang.Object

org.primefaces.extensions.component.exporter.Exporter

org.primefaces.extensions.component.exporter.ExcelExporter

public class ExcelExporter
extends Exporter

Exporter component.

Since:

0.7.0

Author:

Sudheer Jonna / last modified by $Author$

Nested Class Summary

Nested classes/interfaces inherited from class org.primefaces.extensions.component.exporter.Exporter

Exporter.ColumnType

Field Summary

Fields inherited from class org.primefaces.extensions.component.exporter.Exporter

skipComponents

Constructor Summary

Constructors

Constructor	Description
ExcelExporter()

Method Summary

Modifier and Type	Method	Description
protected void	addColumnAlignments(javax.faces.component.UIComponent component, org.apache.poi.ss.usermodel.Cell cell)
protected void	addColumnFacets(org.primefaces.component.datatable.DataTable table, org.apache.poi.ss.usermodel.Sheet sheet, Exporter.ColumnType columnType)
protected void	addColumnFacets(org.primefaces.component.subtable.SubTable table, org.apache.poi.ss.usermodel.Sheet sheet, Exporter.ColumnType columnType)
protected void	addColumnValue(org.apache.poi.ss.usermodel.Row row, List<javax.faces.component.UIComponent> components, String columnType, org.primefaces.component.api.UIColumn column)
protected void	addColumnValue(org.apache.poi.ss.usermodel.Row row, javax.faces.component.UIComponent component, String type)
protected void	addFacetAlignments(javax.faces.component.UIComponent component, org.apache.poi.ss.usermodel.Cell cell)
protected void	createCustomFonts()
void	customFormat(String facetBackground, String facetFontSize, String facetFontColor, String facetFontStyle, String fontName, String cellFontSize, String cellFontColor, String cellFontStyle, String datasetPadding, String orientation)
void	export(javax.faces.event.ActionEvent event, String tableId, javax.faces.context.FacesContext context, String filename, String tableTitle, boolean pageOnly, boolean selectionOnly, String encodingType, javax.el.MethodExpression preProcessor, javax.el.MethodExpression postProcessor, boolean subTable)
protected void	exportAll(javax.faces.context.FacesContext context, org.primefaces.component.datalist.DataList list, org.apache.poi.ss.usermodel.Sheet sheet)
protected void	exportAll(javax.faces.context.FacesContext context, org.primefaces.component.datatable.DataTable table, org.apache.poi.ss.usermodel.Sheet sheet, Boolean subTable)
protected void	exportAll(javax.faces.context.FacesContext context, org.primefaces.component.subtable.SubTable table, org.apache.poi.ss.usermodel.Sheet sheet)
protected void	exportCells(org.primefaces.component.datalist.DataList list, org.apache.poi.ss.usermodel.Sheet sheet)
protected void	exportCells(org.primefaces.component.datatable.DataTable table, org.apache.poi.ss.usermodel.Sheet sheet)
protected void	exportCells(org.primefaces.component.subtable.SubTable table, org.apache.poi.ss.usermodel.Sheet sheet)
protected void	exportPageOnly(javax.faces.context.FacesContext context, org.primefaces.component.datalist.DataList list, org.apache.poi.ss.usermodel.Sheet sheet)
protected void	exportPageOnly(javax.faces.context.FacesContext context, org.primefaces.component.datatable.DataTable table, org.apache.poi.ss.usermodel.Sheet sheet)
protected void	exportRow(org.primefaces.component.datalist.DataList list, org.apache.poi.ss.usermodel.Sheet sheet, int rowIndex)
protected void	exportRow(org.primefaces.component.datatable.DataTable table, org.apache.poi.ss.usermodel.Sheet sheet, int rowIndex)
protected void	exportRow(org.primefaces.component.subtable.SubTable table, org.apache.poi.ss.usermodel.Sheet sheet, int rowIndex)
protected void	exportSelectionOnly(javax.faces.context.FacesContext context, org.primefaces.component.datatable.DataTable table, org.apache.poi.ss.usermodel.Sheet sheet)
protected void	tableColumnGroup(org.apache.poi.ss.usermodel.Sheet sheet, org.primefaces.component.datatable.DataTable table, String facetType)
protected void	tableColumnGroup(org.apache.poi.ss.usermodel.Sheet sheet, org.primefaces.component.subtable.SubTable table, String facetType)
protected void	tableFacet(javax.faces.context.FacesContext context, org.apache.poi.ss.usermodel.Sheet sheet, org.primefaces.component.datalist.DataList list, String facetType)
protected void	tableFacet(javax.faces.context.FacesContext context, org.apache.poi.ss.usermodel.Sheet sheet, org.primefaces.component.datatable.DataTable table, int columnCount, String facetType)
protected void	tableFacet(javax.faces.context.FacesContext context, org.apache.poi.ss.usermodel.Sheet sheet, org.primefaces.component.subtable.SubTable table, int columnCount, String facetType)
protected void	writeExcelToResponse(javax.faces.context.ExternalContext externalContext, org.apache.poi.ss.usermodel.Workbook generatedExcel, String filename)

Methods inherited from class org.primefaces.extensions.component.exporter.Exporter

addColumnValues, exportColumnByFunction, exportFacetValue, exportValue, getColumnsCount, getColumnsCount, getColumnsToExport, hasFooterColumn, hasHeaderColumn, hasHeaderColumn, setSkipComponents

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelExporter

public ExcelExporter()

Method Detail

export

public void export(javax.faces.event.ActionEvent event,
                   String tableId,
                   javax.faces.context.FacesContext context,
                   String filename,
                   String tableTitle,
                   boolean pageOnly,
                   boolean selectionOnly,
                   String encodingType,
                   javax.el.MethodExpression preProcessor,
                   javax.el.MethodExpression postProcessor,
                   boolean subTable)
            throws IOException

Specified by:

export in class Exporter

Throws:

IOException

exportAll

protected void exportAll(javax.faces.context.FacesContext context,
                         org.primefaces.component.datatable.DataTable table,
                         org.apache.poi.ss.usermodel.Sheet sheet,
                         Boolean subTable)

exportAll

protected void exportAll(javax.faces.context.FacesContext context,
                         org.primefaces.component.subtable.SubTable table,
                         org.apache.poi.ss.usermodel.Sheet sheet)

exportAll

protected void exportAll(javax.faces.context.FacesContext context,
                         org.primefaces.component.datalist.DataList list,
                         org.apache.poi.ss.usermodel.Sheet sheet)

exportPageOnly

protected void exportPageOnly(javax.faces.context.FacesContext context,
                              org.primefaces.component.datatable.DataTable table,
                              org.apache.poi.ss.usermodel.Sheet sheet)

exportPageOnly

protected void exportPageOnly(javax.faces.context.FacesContext context,
                              org.primefaces.component.datalist.DataList list,
                              org.apache.poi.ss.usermodel.Sheet sheet)

exportSelectionOnly

protected void exportSelectionOnly(javax.faces.context.FacesContext context,
                                   org.primefaces.component.datatable.DataTable table,
                                   org.apache.poi.ss.usermodel.Sheet sheet)

tableFacet

protected void tableFacet(javax.faces.context.FacesContext context,
                          org.apache.poi.ss.usermodel.Sheet sheet,
                          org.primefaces.component.datatable.DataTable table,
                          int columnCount,
                          String facetType)

tableFacet

protected void tableFacet(javax.faces.context.FacesContext context,
                          org.apache.poi.ss.usermodel.Sheet sheet,
                          org.primefaces.component.subtable.SubTable table,
                          int columnCount,
                          String facetType)

tableFacet

protected void tableFacet(javax.faces.context.FacesContext context,
                          org.apache.poi.ss.usermodel.Sheet sheet,
                          org.primefaces.component.datalist.DataList list,
                          String facetType)

tableColumnGroup

protected void tableColumnGroup(org.apache.poi.ss.usermodel.Sheet sheet,
                                org.primefaces.component.datatable.DataTable table,
                                String facetType)

tableColumnGroup

protected void tableColumnGroup(org.apache.poi.ss.usermodel.Sheet sheet,
                                org.primefaces.component.subtable.SubTable table,
                                String facetType)

exportRow

protected void exportRow(org.primefaces.component.datatable.DataTable table,
                         org.apache.poi.ss.usermodel.Sheet sheet,
                         int rowIndex)

exportRow

protected void exportRow(org.primefaces.component.subtable.SubTable table,
                         org.apache.poi.ss.usermodel.Sheet sheet,
                         int rowIndex)

exportRow

protected void exportRow(org.primefaces.component.datalist.DataList list,
                         org.apache.poi.ss.usermodel.Sheet sheet,
                         int rowIndex)

exportCells

protected void exportCells(org.primefaces.component.datatable.DataTable table,
                           org.apache.poi.ss.usermodel.Sheet sheet)

exportCells

protected void exportCells(org.primefaces.component.subtable.SubTable table,
                           org.apache.poi.ss.usermodel.Sheet sheet)

exportCells

protected void exportCells(org.primefaces.component.datalist.DataList list,
                           org.apache.poi.ss.usermodel.Sheet sheet)

addColumnFacets

protected void addColumnFacets(org.primefaces.component.datatable.DataTable table,
                               org.apache.poi.ss.usermodel.Sheet sheet,
                               Exporter.ColumnType columnType)

addColumnFacets

protected void addColumnFacets(org.primefaces.component.subtable.SubTable table,
                               org.apache.poi.ss.usermodel.Sheet sheet,
                               Exporter.ColumnType columnType)

addColumnValue

protected void addColumnValue(org.apache.poi.ss.usermodel.Row row,
                              javax.faces.component.UIComponent component,
                              String type)

addColumnValue

protected void addColumnValue(org.apache.poi.ss.usermodel.Row row,
                              List<javax.faces.component.UIComponent> components,
                              String columnType,
                              org.primefaces.component.api.UIColumn column)

addColumnAlignments

protected void addColumnAlignments(javax.faces.component.UIComponent component,
                                   org.apache.poi.ss.usermodel.Cell cell)

addFacetAlignments

protected void addFacetAlignments(javax.faces.component.UIComponent component,
                                  org.apache.poi.ss.usermodel.Cell cell)

customFormat

public void customFormat(String facetBackground,
                         String facetFontSize,
                         String facetFontColor,
                         String facetFontStyle,
                         String fontName,
                         String cellFontSize,
                         String cellFontColor,
                         String cellFontStyle,
                         String datasetPadding,
                         String orientation)

Specified by:

customFormat in class Exporter

createCustomFonts

protected void createCustomFonts()

writeExcelToResponse

protected void writeExcelToResponse(javax.faces.context.ExternalContext externalContext,
                                    org.apache.poi.ss.usermodel.Workbook generatedExcel,
                                    String filename)
                             throws IOException

Throws:

IOException