| 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 are hided or not. Default is false. |
| is_version | A string which value is an Excel version. Available values are: '5', '97'. 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. |
| 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_header_font | A string value. The font name. Default: Arial. |
| il_header_font_family | A long value. The font family. 0 - AnyFont, 1 - Roman, 2 - Swiss, 3 - Modern, 4 - Script, 5 - Decorative. Default: 0. |
| il_header_font_charset | A long value. The font charset. 0 - Ansi, 1 - default, 2 - Symbol, 128 - Shift JIS, 255 - OEM. Default: 0. |
| il_header_fg_color | A long value. The foreground color. Use RGB(). Default: Black |
| il_header_bg_color | A long value. The background color. Use RGB(). Default: White |
| is_header_text_align | A string value. The alignment of the text inside the header cell ("center"|"left"|"right"). Default: center. |
| is_header_align | A string value. The alignment of the header cell inside the page ("center"|"left"|"right"). Default: left. |
| il_header_font_size | A long value. The font size. Default: 10. |
| ib_header_font_bold | A boolean value. The font is bold. Default: True |
| ib_header_font_underline | A boolean value. The font is underlined. Default: False. |
| ib_header_font_italic | A boolean value. The font is italic. Default: False. |
| il_header_height | A long value. The height of header cell (DW units).Default: 100. |
| il_header_width | A long value. The width of header cell (DW units).Default: 2800. |
| il_header_separator_height | A long value. The height of empty row separating the header from the rest of data. Default: 0. |