Following table shows the depiction of the configuration parameters.
Parameter name |
Description |
FORMAT_TYPE |
Can be set as "EXCEL97TO2003" or "EXCEL2007" to generate EXCEL97TO2003 or EXCEL2007 format file. |
IS_ONE_PAGE_PER_SHEET |
A Boolean value specifying whether each report page should be written in a different XLS sheet |
IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS |
A Boolean value specifying whether the empty spaces that could appear between rows should be removed or not. |
IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS |
A Boolean value specifying whether the empty spaces that could appear between columns should be removed or not. |
IS_WHITE_PAGE_BACKGROUND |
A Boolean value specifying whether the page background should be white or the default XLS background color. This background may vary depending on the XLS viewer properties or the operating system color scheme. |
IS_DETECT_CELL_TYPE |
Flag used to indicate whether the exporter should take into consideration the type of the original text field expressions and set the cell types and values accordingly. |
SHEET_NAMES |
An array of strings representing custom sheet names. This is useful when used with the IS_ONE_PAGE_PER_SHEET parameter. |
IS_FONT_SIZE_FIX_ENABLED |
Flag for decreasing font size so that text fits into the specified cell height. |
MAXIMUM_ROWS_PER_SHEET |
An integer value specifying the maximum number of rows allowed to be shown in a sheet. When set, a new sheet is created for the remaining rows to be displayed. Negative values or zero means no limit has been set. |
IS_IGNORE_GRAPHICS |
Flag for ignoring graphical elements and exporting text elements only. |
IS_COLLAPSE_ROW_SPAN |
Flag for collapsing row span and avoid merging cells across rows. |
IS_IGNORE_CELL_BORDER |
Flag for ignoring the cell border. |
IS_USE_EXCEL_CHART |
Flag for using editable chart in excel format rather than static pictures. Default value is true. |