it.eng.spagobi.engines.worksheet.exporter
Class WorkSheetXLSXExporter
java.lang.Object
it.eng.spagobi.engines.worksheet.exporter.WorkSheetXLSExporter
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, STATIC_CROSSTAB, SVG, TABLE, TABLE_CELL_CONTENT_FONT_SIZE, TABLE_HEADER_FONT_SIZE, TITLE |
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 |
logger
public static transient org.apache.log4j.Logger logger
- Logger component.
WorkSheetXLSXExporter
public WorkSheetXLSXExporter()
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