Excel 2007 Output Properties

Use the properties described in this table to control Excel 2007 output.

Property Name	Description
Show grid lines	Default: false Description: Set to true to show the Excel table grid lines in the report output.
Page break as a new sheet	Default: true Description: When set to True a page break that is specified in the report template generates a new sheet in the Excel workbook.
Minimum column width	Default: 3 (in points, 0.04 inch) Description: When the column width is less than the specified minimum and it contains no data, the column is merged with the preceding column. The value must be set in points. The valid range for this property is 0.5 to 20 points.
Minimum row height	Default: 1 (in points, 0.01 inch) Description: When the row height is less than the specified minimum and it contains no data, the row is removed. The value must be set in points. The valid range for this property is .001 to 5 points.
Keep values in same column	Default: False Description: Set this property to True to minimize column merging. Column width is set based on column contents using the values supplied in the Table Auto Layout property. Output may not appear as neatly laid out as when using the original layout algorithm.
Table Auto Layout	Default: N/A Valid Values: Specify a conversion ratio in points and a maximum length in points, for example 6.5,150. See example. Description: For this property to take effect, the property "Keep values in same column" must be set to True. This property expands the table column width to fit the contents. The column width is expanded based on the character count and conversion ratio up to the maximum specification. Example: Assume a report with two columns of Excel data -- Column 1 contains a text string that is 18 characters and Column 2 is 30 characters long. When the value of this property is set to 6.5,150, the following calculations are performed: Column 1 is 18 characters: Apply the calculation: 18 * 6.5pts = 117 pts The column in the Excel output will be 117 pts wide. Column 2 is 30 characters: Apply the calculation: 30 * 6.5 pts = 195 pts Because 195 pts is greater than the specified maximum of 150, Column 2 will be 150 pts wide in the Excel output.
Maximum allowable nested table row count	Default: 20,000 Description: Specify the maximum allowable row count for a nested table. Allowed values are 15000 to 999,999. During report processing, nested inner table rows cannot be flushed to the XLSX writer, therefore they stay in-memory, increasing memory consumption. Set this limit to avoid out-of-memory exceptions. When this limit is reached for the size of the inner table, generation is terminated. The incomplete XLSX output file is returned.