it.eng.spagobi.engines.qbe.exporter
Class QbeXLSExporter
java.lang.Object
it.eng.spagobi.engines.qbe.exporter.QbeXLSExporter
- Direct Known Subclasses:
- QbeXLSXExporter
public class QbeXLSExporter
- extends java.lang.Object
Constructor Summary |
QbeXLSExporter()
|
QbeXLSExporter(it.eng.spagobi.tools.dataset.common.datastore.IDataStore dataStore,
java.util.Locale locale)
|
Method Summary |
org.apache.poi.ss.usermodel.CellStyle |
buildCellStyle(org.apache.poi.ss.usermodel.Sheet sheet)
|
org.apache.poi.ss.usermodel.CellStyle |
buildHeaderCellStyle(org.apache.poi.ss.usermodel.Sheet sheet)
|
org.apache.poi.ss.usermodel.Workbook |
export()
|
void |
fillSheet(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook wb,
org.apache.poi.ss.usermodel.CreationHelper createHelper,
int startRow)
|
void |
fillSheetData(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook wb,
org.apache.poi.ss.usermodel.CreationHelper createHelper,
org.apache.poi.ss.usermodel.CellStyle[] cellTypes,
int beginRowData,
int beginColumnData)
|
org.apache.poi.ss.usermodel.CellStyle[] |
fillSheetHeader(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook wb,
org.apache.poi.ss.usermodel.CreationHelper createHelper,
int beginRowHeaderData,
int beginColumnHeaderData)
|
protected short |
getBuiltinFormat(java.lang.String formatStr)
|
protected int |
getCellTypeBoolean()
|
protected int |
getCellTypeNumeric()
|
protected int |
getCellTypeString()
|
it.eng.spagobi.tools.dataset.common.datastore.IDataStore |
getDataStore()
|
java.lang.Object |
getProperty(java.lang.String propertyName)
|
protected org.apache.poi.ss.usermodel.Workbook |
instantiateWorkbook()
|
void |
setDataStore(it.eng.spagobi.tools.dataset.common.datastore.IDataStore dataStore)
|
void |
setExtractedFields(java.util.Vector extractedFields)
|
void |
setProperty(java.lang.String propertyName,
java.lang.Object propertyValue)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
logger
public static transient org.apache.log4j.Logger logger
- Logger component.
PROPERTY_HEADER_FONT_SIZE
public static final java.lang.String PROPERTY_HEADER_FONT_SIZE
- Configuration properties
- See Also:
- Constant Field Values
PROPERTY_HEADER_COLOR
public static final java.lang.String PROPERTY_HEADER_COLOR
- See Also:
- Constant Field Values
PROPERTY_HEADER_BACKGROUND_COLOR
public static final java.lang.String PROPERTY_HEADER_BACKGROUND_COLOR
- See Also:
- Constant Field Values
PROPERTY_HEADER_BORDER_COLOR
public static final java.lang.String PROPERTY_HEADER_BORDER_COLOR
- See Also:
- Constant Field Values
PROPERTY_CELL_FONT_SIZE
public static final java.lang.String PROPERTY_CELL_FONT_SIZE
- See Also:
- Constant Field Values
PROPERTY_CELL_COLOR
public static final java.lang.String PROPERTY_CELL_COLOR
- See Also:
- Constant Field Values
PROPERTY_CELL_BACKGROUND_COLOR
public static final java.lang.String PROPERTY_CELL_BACKGROUND_COLOR
- See Also:
- Constant Field Values
PROPERTY_CELL_BORDER_COLOR
public static final java.lang.String PROPERTY_CELL_BORDER_COLOR
- See Also:
- Constant Field Values
PROPERTY_FONT_NAME
public static final java.lang.String PROPERTY_FONT_NAME
- See Also:
- Constant Field Values
DEFAULT_HEADER_FONT_SIZE
public static final short DEFAULT_HEADER_FONT_SIZE
- See Also:
- Constant Field Values
DEFAULT_HEADER_COLOR
public static final java.lang.String DEFAULT_HEADER_COLOR
- See Also:
- Constant Field Values
DEFAULT_HEADER_BACKGROUND_COLOR
public static final java.lang.String DEFAULT_HEADER_BACKGROUND_COLOR
- See Also:
- Constant Field Values
DEFAULT_HEADER_BORDER_COLOR
public static final java.lang.String DEFAULT_HEADER_BORDER_COLOR
- See Also:
- Constant Field Values
DEFAULT_CELL_FONT_SIZE
public static final short DEFAULT_CELL_FONT_SIZE
- See Also:
- Constant Field Values
DEFAULT_CELL_COLOR
public static final java.lang.String DEFAULT_CELL_COLOR
- See Also:
- Constant Field Values
DEFAULT_CELL_BACKGROUND_COLOR
public static final java.lang.String DEFAULT_CELL_BACKGROUND_COLOR
- See Also:
- Constant Field Values
DEFAULT_CELL_BORDER_COLOR
public static final java.lang.String DEFAULT_CELL_BORDER_COLOR
- See Also:
- Constant Field Values
DEFAULT_DIMENSION_NAME_COLOR
public static final java.lang.String DEFAULT_DIMENSION_NAME_COLOR
- See Also:
- Constant Field Values
DEFAULT_DIMENSION_NAME_BACKGROUND_COLOR
public static final java.lang.String DEFAULT_DIMENSION_NAME_BACKGROUND_COLOR
- See Also:
- Constant Field Values
DEFAULT_FONT_NAME
public static final java.lang.String DEFAULT_FONT_NAME
- See Also:
- Constant Field Values
DEFAULT_DECIMAL_PRECISION
public static final int DEFAULT_DECIMAL_PRECISION
- See Also:
- Constant Field Values
DEFAULT_START_COLUMN
public static final int DEFAULT_START_COLUMN
- See Also:
- Constant Field Values
QbeXLSExporter
public QbeXLSExporter(it.eng.spagobi.tools.dataset.common.datastore.IDataStore dataStore,
java.util.Locale locale)
QbeXLSExporter
public QbeXLSExporter()
getDataStore
public it.eng.spagobi.tools.dataset.common.datastore.IDataStore getDataStore()
setDataStore
public void setDataStore(it.eng.spagobi.tools.dataset.common.datastore.IDataStore dataStore)
setProperty
public void setProperty(java.lang.String propertyName,
java.lang.Object propertyValue)
getProperty
public java.lang.Object getProperty(java.lang.String propertyName)
export
public org.apache.poi.ss.usermodel.Workbook export()
fillSheet
public void fillSheet(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook wb,
org.apache.poi.ss.usermodel.CreationHelper createHelper,
int startRow)
fillSheetHeader
public org.apache.poi.ss.usermodel.CellStyle[] fillSheetHeader(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook wb,
org.apache.poi.ss.usermodel.CreationHelper createHelper,
int beginRowHeaderData,
int beginColumnHeaderData)
buildHeaderCellStyle
public org.apache.poi.ss.usermodel.CellStyle buildHeaderCellStyle(org.apache.poi.ss.usermodel.Sheet sheet)
buildCellStyle
public org.apache.poi.ss.usermodel.CellStyle buildCellStyle(org.apache.poi.ss.usermodel.Sheet sheet)
fillSheetData
public void fillSheetData(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook wb,
org.apache.poi.ss.usermodel.CreationHelper createHelper,
org.apache.poi.ss.usermodel.CellStyle[] cellTypes,
int beginRowData,
int beginColumnData)
setExtractedFields
public void setExtractedFields(java.util.Vector extractedFields)
instantiateWorkbook
protected org.apache.poi.ss.usermodel.Workbook instantiateWorkbook()
getCellTypeNumeric
protected int getCellTypeNumeric()
getCellTypeString
protected int getCellTypeString()
getCellTypeBoolean
protected int getCellTypeBoolean()
getBuiltinFormat
protected short getBuiltinFormat(java.lang.String formatStr)