| ib_header | A boolean value which controls whether the header band converting will be allowed. Default is true. |
| ib_foreground | A boolean value which controls whether the foreground band converting will be allowed. Default is true. |
| ib_background | A boolean value which controls whether the background band converting will be allowed. Default is true. |
| ib_detail | A boolean value which controls whether the detail band converting will be allowed. Default is true. |
| ib_summary | A boolean value which controls whether the summary band converting will be allowed. Default is true. |
| ib_footer | A boolean value which controls whether the footer band converting will be allowed. Default is true. |
| ib_group_header | A boolean value which controls whether the group headers converting will be allowed. Default is true. |
| ib_group_trailer | A boolean value which controls whether the group trailers converting will be allowed. Default is true. |
| ib_keep_band_height | A boolean value which controls whether should be kept the height of all bands. Default is false. |
| ib_enable_merge_cells | A boolean value which controls whether or not the cells can be merged. Default is true. |
| ib_show_progress | A boolean value which determines whether or not the progress bar should be displayed. Default is true. |
| ib_hide_grid | A boolean value which controls whether grid lines for resulting document are hided or not. Default is false. |
| is_version | A string which value is an Excel version. Available values are: '97', 'OOXML'. Default is '97' |
| is_sheet_name | A string which value is a Worksheet name. Default is 'Sheet1'. |
| ib_group_pagebreak | A boolean value which controls whether the pagebreak will be added into Excel file for each group break if the option "New Page on Group Break" is set. Default is false. |
| ib_group_pageheader | A boolean value which controls whether the band "header" will be added for each page if the options "New Page on Group Break" is set. Default is true. |
| ib_nested | A boolean value which controls whether Nested DW will be converted or not. Default is true. |
| id_min_width | A double value which controls the minimum width of columns in Excel units. |
| id_min_height | A double value which controls the minimum height of rows in Excel units. |
| ib_background_color | A boolean value which controls whether band background colors are exported. Default is false. |
| ib_lines | Export lines(not inclined). Default is false. |
| ib_rectangles | Export rectangles. Default is false. |
| ib_trim_overlapped | Switch On/Off trimming of overlapping objects. Default is true. |
| ib_export_invisible | Switch On/Off export of invisible objects. Default is false |
| ib_always_export_grid_header | If false, then objects in header will not be exported if they are positioned behind max detail column X-coordinate. Default is true |
| ib_font_height_expression | Switch On/Off font height expression calculation. Default is true. |
| ib_grid_columns_by_rowheight | If true, then for Grid DWs columns will have height = RowHeight(). Default is true. |
| ib_export_hidden_treeview_levels | If true, then for TreeView DWs collapsed levels will be exported too. Default is true. |
| ib_nested_workaround | If true, then for nested reports will modify source DW directly to obtain child reports. For Appeon only. Default is false. |
| ib_check_suppressed | If true, then will consider Suppress Repeating Values setting. Default is false. |
| ib_pictures | If true, then will export pictures. For OOXML format only. Default is false. |
| ib_draw_dw_grid_lines | If true, then will draw dash border for fields with invisible border when exporting Grid DW. Default is true. |
| ib_fix_date_base | If true, then will apply workaround for dates before 1900-03-01 which are calculated in Excel in a different way in comparison to OpenOffice and LibreOffice. |
| ib_nonvisual_calc_height | If true, then will use nonvisual object to calculate height for autoheight columns. Doesn't work on Appeon. Default is false. |
| ib_ignore_autosizeheight | If true, then will ignore column height autosize. Default is false. |
| XLS header related parameters |
| is_header_text |
A string value. The text to be added in top of XLS.
If is_header_text = "" then the rest of header parameters are ignored
and the header is not generated.
|
| is_title_font | A string value. The font name. Default: Arial. |
| il_title_font_family | A long value. The font family. 0 - AnyFont, 1 - Roman, 2 - Swiss, 3 - Modern, 4 - Script, 5 - Decorative. Default: 0. |
| il_title_font_charset | A long value. The font charset. 0 - Ansi, 1 - default, 2 - Symbol, 128 - Shift JIS, 255 - OEM. Default: 0. |
| il_title_fg_color | A long value. The foreground color. Use RGB(). Default: Black |
| il_title_bg_color | A long value. The background color. Use RGB(). Default: White |
| is_title_text_align | A string value. The alignment of the text inside the header cell ("center"|"left"|"right"). Default: center. |
| is_title_align | A string value. The alignment of the header cell inside the page ("center"|"left"|"right"). Default: left. |
| il_title_font_size | A long value. The font size. Default: 10. |
| ib_title_font_bold | A boolean value. The font is bold. Default: True |
| ib_title_font_underline | A boolean value. The font is underlined. Default: False. |
| ib_title_font_italic | A boolean value. The font is italic. Default: False. |
| il_title_height | A long value. The height of header cell (DW units).Default: 100. |
| il_title_width | A long value. The width of header cell (DW units).Default: 2800. |
| il_title_separator_height | A long value. The height of empty row separating the header from the rest of data. Default: 0. |
