it.eng.spagobi.engines.qbe.exporter
Class QbeXLSExporter

java.lang.Object
  extended by it.eng.spagobi.engines.qbe.exporter.QbeXLSExporter
Direct Known Subclasses:
QbeXLSXExporter

public class QbeXLSExporter
extends java.lang.Object


Field Summary
static java.lang.String DEFAULT_CELL_BACKGROUND_COLOR
           
static java.lang.String DEFAULT_CELL_BORDER_COLOR
           
static java.lang.String DEFAULT_CELL_COLOR
           
static short DEFAULT_CELL_FONT_SIZE
           
static int DEFAULT_DECIMAL_PRECISION
           
static java.lang.String DEFAULT_DIMENSION_NAME_BACKGROUND_COLOR
           
static java.lang.String DEFAULT_DIMENSION_NAME_COLOR
           
static java.lang.String DEFAULT_FONT_NAME
           
static java.lang.String DEFAULT_HEADER_BACKGROUND_COLOR
           
static java.lang.String DEFAULT_HEADER_BORDER_COLOR
           
static java.lang.String DEFAULT_HEADER_COLOR
           
static short DEFAULT_HEADER_FONT_SIZE
           
static int DEFAULT_START_COLUMN
           
static org.apache.log4j.Logger logger
          Logger component.
static java.lang.String PROPERTY_CELL_BACKGROUND_COLOR
           
static java.lang.String PROPERTY_CELL_BORDER_COLOR
           
static java.lang.String PROPERTY_CELL_COLOR
           
static java.lang.String PROPERTY_CELL_FONT_SIZE
           
static java.lang.String PROPERTY_FONT_NAME
           
static java.lang.String PROPERTY_HEADER_BACKGROUND_COLOR
           
static java.lang.String PROPERTY_HEADER_BORDER_COLOR
           
static java.lang.String PROPERTY_HEADER_COLOR
           
static java.lang.String PROPERTY_HEADER_FONT_SIZE
          Configuration properties
 
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)
           
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
 

Field Detail

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
Constructor Detail

QbeXLSExporter

public QbeXLSExporter(it.eng.spagobi.tools.dataset.common.datastore.IDataStore dataStore,
                      java.util.Locale locale)

QbeXLSExporter

public QbeXLSExporter()
Method Detail

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)

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)