it.eng.spagobi.engines.qbe.crosstable.exporter
Class CrosstabXLSXExporter

java.lang.Object
  extended by it.eng.spagobi.engines.qbe.crosstable.exporter.CrosstabXLSExporter
      extended by it.eng.spagobi.engines.qbe.crosstable.exporter.CrosstabXLSXExporter

public class CrosstabXLSXExporter
extends CrosstabXLSExporter

Exports the crosstab data (formatted as a JSON object in input) into a XLSX file. The JSON object should have this structure (a node is {node_key:"Text", node_childs:[...]}): columns: {...} contains tree node structure of the columns' headers rows: {...} contains tree node structure of the rows' headers data: [[...], [...], ...] 2-dimensional matrix containing crosstab data

Author:
Alberto Ghedin (alberto.ghedin@eng.it), Davide Zerbetto (davide.zerbetto@eng.it)

Field Summary
static org.apache.log4j.Logger logger
          Logger component.
 
Fields inherited from class it.eng.spagobi.engines.qbe.crosstable.exporter.CrosstabXLSExporter
DEFAULT_CALCULATED_FIELD_DECIMALS, DEFAULT_CELL_BACKGROUND_COLOR, DEFAULT_CELL_BORDER_COLOR, DEFAULT_CELL_COLOR, DEFAULT_CELL_FONT_SIZE, DEFAULT_DIMENSION_NAME_BACKGROUND_COLOR, DEFAULT_DIMENSION_NAME_COLOR, DEFAULT_FONT_NAME, DEFAULT_HEADER_BACKGROUND_COLOR, DEFAULT_HEADER_BORDER_COLOR, DEFAULT_HEADER_COLOR, DEFAULT_HEADER_FONT_SIZE, PROPERTY_CALCULATED_FIELD_DECIMALS, PROPERTY_CELL_BACKGROUND_COLOR, PROPERTY_CELL_BORDER_COLOR, PROPERTY_CELL_COLOR, PROPERTY_CELL_FONT_SIZE, PROPERTY_DIMENSION_NAME_BACKGROUND_COLOR, PROPERTY_DIMENSION_NAME_COLOR, PROPERTY_FONT_NAME, PROPERTY_HEADER_BACKGROUND_COLOR, PROPERTY_HEADER_BORDER_COLOR, PROPERTY_HEADER_COLOR, PROPERTY_HEADER_FONT_SIZE
 
Constructor Summary
CrosstabXLSXExporter(java.util.Properties properties)
           
 
Method Summary
protected  int getCellTypeNumeric()
           
protected  int getCellTypeString()
           
 
Methods inherited from class it.eng.spagobi.engines.qbe.crosstable.exporter.CrosstabXLSExporter
buildColumnsHeader, buildDataCellStyle, buildDataMatrix, buildDimensionCellStyle, buildHeaderCellStyle, buildNACellStyle, buildRowHeaderTitle, buildRowsHeaders, commonFillSheet, fillAlreadyCreatedSheet, getCalculatedFieldDecimals, getNumberFormat, getProperty, initSheet, setProperty
 
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.

Constructor Detail

CrosstabXLSXExporter

public CrosstabXLSXExporter(java.util.Properties properties)
Method Detail

getCellTypeNumeric

protected int getCellTypeNumeric()
Overrides:
getCellTypeNumeric in class CrosstabXLSExporter

getCellTypeString

protected int getCellTypeString()
Overrides:
getCellTypeString in class CrosstabXLSExporter