it.eng.spagobi.engines.worksheet.exporter
Class WorkSheetXLSXExporter

java.lang.Object
  extended by it.eng.spagobi.engines.worksheet.exporter.WorkSheetXLSExporter
      extended by it.eng.spagobi.engines.worksheet.exporter.WorkSheetXLSXExporter

public class WorkSheetXLSXExporter
extends WorkSheetXLSExporter

Exports the crosstab data (formatted as a JSON object in input) into a XLS 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:
Chiara Chiarelli

Field Summary
static org.apache.log4j.Logger logger
          Logger component.
 
Fields inherited from class it.eng.spagobi.engines.worksheet.exporter.WorkSheetXLSExporter
CENTER, CHART, CONTENT, CROSSTAB, CROSSTAB_JSON_DESCENDANTS_NUMBER, EXPORTED_SHEETS, FILTERS_TITLE_FONT_SIZE, FILTERS_VALUES_FONT_SIZE, FONT_NAME, FOOTER, HEADER, HEADER_FONT_SIZE, IMG, LEFT, METADATA_NAME_FONT_SIZE, METADATA_TITLE_FONT_SIZE, METADATA_VALUE_FONT_SIZE, OUTPUT_FORMAT_JPEG, POSITION, RIGHT, SHEET_TYPE, SHEETS_NUM, SVG, TABLE, TABLE_CELL_CONTENT_FONT_SIZE, TABLE_HEADER_FONT_SIZE, TITLE
 
Constructor Summary
WorkSheetXLSXExporter()
           
 
Method Summary
 org.apache.poi.ss.usermodel.Workbook createNewWorkbook()
           
 void designTableInWorksheet(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Workbook wb, org.apache.poi.ss.usermodel.CreationHelper createHelper, it.eng.spagobi.tools.dataset.common.datastore.IDataStore dataStore, int startRow, java.util.Locale locale)
           
 int getCellTypeBoolean()
           
 int getCellTypeNumeric()
           
 int getCellTypeString()
           
protected  org.apache.poi.ss.usermodel.ClientAnchor getClientAnchor(int col, int colend, int sheetRow, int height, int dx1, int dy1, int dx2, int dy2)
           
 int getImageType(java.lang.String imgNameUpperCase)
           
 
Methods inherited from class it.eng.spagobi.engines.worksheet.exporter.WorkSheetXLSExporter
buildFiltersTitleCellStyle, buildFiltersValuesCellStyle, buildHeaderTitleCellStyle, buildMetadataNameCellStyle, buildMetadataTitleCellStyle, buildMetadataValueCellStyle, createJPGImage, createPNGImage, getImage, getJsonVisibleSelectFields, getOptionalUserFilters, setFooter, setHeader, setImageIntoWorkSheet, transformSVGIntoJPEG
 
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

WorkSheetXLSXExporter

public WorkSheetXLSXExporter()
Method Detail

createNewWorkbook

public org.apache.poi.ss.usermodel.Workbook createNewWorkbook()
Overrides:
createNewWorkbook in class WorkSheetXLSExporter

designTableInWorksheet

public void designTableInWorksheet(org.apache.poi.ss.usermodel.Sheet sheet,
                                   org.apache.poi.ss.usermodel.Workbook wb,
                                   org.apache.poi.ss.usermodel.CreationHelper createHelper,
                                   it.eng.spagobi.tools.dataset.common.datastore.IDataStore dataStore,
                                   int startRow,
                                   java.util.Locale locale)
                            throws org.json.JSONException
Overrides:
designTableInWorksheet in class WorkSheetXLSExporter
Throws:
org.json.JSONException

getCellTypeNumeric

public int getCellTypeNumeric()
Overrides:
getCellTypeNumeric in class WorkSheetXLSExporter

getCellTypeString

public int getCellTypeString()
Overrides:
getCellTypeString in class WorkSheetXLSExporter

getCellTypeBoolean

public int getCellTypeBoolean()
Overrides:
getCellTypeBoolean in class WorkSheetXLSExporter

getImageType

public int getImageType(java.lang.String imgNameUpperCase)
Overrides:
getImageType in class WorkSheetXLSExporter

getClientAnchor

protected org.apache.poi.ss.usermodel.ClientAnchor getClientAnchor(int col,
                                                                   int colend,
                                                                   int sheetRow,
                                                                   int height,
                                                                   int dx1,
                                                                   int dy1,
                                                                   int dx2,
                                                                   int dy2)
Overrides:
getClientAnchor in class WorkSheetXLSExporter