Package org.primefaces.util
Class ExcelStylesManager
java.lang.Object
org.primefaces.util.ExcelStylesManager
- Direct Known Subclasses:
ExcelXmlStylesManager
-
Field Summary
Modifier and TypeFieldDescriptionprotected static final String
protected final ExcelOptions
protected final org.apache.poi.ss.usermodel.Workbook
-
Constructor Summary
ModifierConstructorDescriptionprotected
ExcelStylesManager
(org.apache.poi.ss.usermodel.Workbook wb, Locale locale, ExcelOptions options) -
Method Summary
Modifier and TypeMethodDescriptionprotected void
applyCellOptions
(org.apache.poi.ss.usermodel.CellStyle style) protected void
applyFacetOptions
(org.apache.poi.ss.usermodel.CellStyle style) static ExcelStylesManager
createExcelStylesManager
(org.apache.poi.ss.usermodel.Workbook wb, Locale locale, ExcelOptions options) org.apache.poi.ss.usermodel.RichTextString
createRichTextString
(String value) protected String
org.apache.poi.ss.usermodel.CellStyle
protected String
protected String
void
updateCell
(UIColumn column, org.apache.poi.ss.usermodel.Cell cell, String value) If ExcelOptions.isStronglyTypedCells = true then for cells check:
-
Field Details
-
DEFAULT_FONT
- See Also:
-
wb
protected final org.apache.poi.ss.usermodel.Workbook wb -
options
-
-
Constructor Details
-
ExcelStylesManager
protected ExcelStylesManager(org.apache.poi.ss.usermodel.Workbook wb, Locale locale, ExcelOptions options)
-
-
Method Details
-
createExcelStylesManager
public static ExcelStylesManager createExcelStylesManager(org.apache.poi.ss.usermodel.Workbook wb, Locale locale, ExcelOptions options) -
updateCell
If ExcelOptions.isStronglyTypedCells = true then for cells check:Numeric - String that are all numbers make them a numeric cell Currency - Convert to currency cell so math can be done in Excel String - fallback to just a normal string cell
Possible future enhancement of Date cells as well.- Parameters:
column
- the column from which value comescell
- the cell to operate onvalue
- the String value to put in the cell
-
getFacetStyle
public org.apache.poi.ss.usermodel.CellStyle getFacetStyle() -
applyFacetOptions
protected void applyFacetOptions(org.apache.poi.ss.usermodel.CellStyle style) -
applyCellOptions
protected void applyCellOptions(org.apache.poi.ss.usermodel.CellStyle style) -
createRichTextString
-
getCurrencyExcelFormat
-
getFormattedIntegerExcelFormat
-
getFormattedDecimalExcelFormat
-