Aspose.Cells for JasperReports

Configuration Parameters

 

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.