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 Excel grid lines are hided or not in resulting Excel-file. 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. |
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. |