Class ExcelExporter


  • public class ExcelExporter
    extends Exporter
    Exporter component.
    Since:
    0.7.0
    Author:
    Sudheer Jonna / last modified by $Author$
    • Constructor Summary

      Constructors 
      Constructor Description
      ExcelExporter()  
    • Method Summary

      All Methods Instance Methods Concrete Methods 
      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)  
    • 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)
      • 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