Developer's reference DW2XLS for PowerBuilder

Reference > n_dwr_service_parm

n_dwr_service_parm object

Object which contain a set of parameters for process of converting.
The following properties are available:

Properties

ib_headerA boolean value which controls whether the header band converting will be allowed. Default is true.
ib_foregroundA boolean value which controls whether the foreground band converting will be allowed. Default is true.
ib_backgroundA boolean value which controls whether the background band converting will be allowed. Default is true.
ib_detailA boolean value which controls whether the detail band converting will be allowed. Default is true.
ib_summaryA boolean value which controls whether the summary band converting will be allowed. Default is true.
ib_footerA boolean value which controls whether the footer band converting will be allowed. Default is true.
ib_group_headerA boolean value which controls whether the group headers converting will be allowed. Default is true.
ib_group_trailerA boolean value which controls whether the group trailers converting will be allowed. Default is true.
ib_keep_band_heightA boolean value which controls whether should be kept the height of all bands. Default is false.
ib_enable_merge_cellsA boolean value which controls whether or not the cells can be merged. Default is true.
ib_show_progressA boolean value which determines whether or not the progress bar should be displayed. Default is true.
ib_hide_gridA boolean value which controls whether Excel grid lines are hided or not in resulting Excel-file. Default is false.
is_versionA string which value is an Excel version. Available values are: '97', 'OOXML'. Default is '97'
is_sheet_nameA string which value is a Worksheet name. Default is 'Sheet1'.
ib_group_pagebreakA 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_pageheaderA 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_nestedA boolean value which controls whether Nested DW will be converted or not. Default is true.
id_min_widthA double value which controls the minimum width of columns in Excel units.
id_min_heightA double value which controls the minimum height of rows in Excel units.
ib_background_colorA boolean value which controls whether band background colors are exported. Default is false.
ib_linesExport lines(not inclined). Default is false.
ib_rectanglesExport rectangles. Default is false.
ib_trim_overlappedSwitch On/Off trimming of overlapping objects. Default is true.
ib_export_invisibleSwitch On/Off export of invisible objects. Default is false
ib_always_export_grid_headerIf 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_expressionSwitch On/Off font height expression calculation. Default is true.
ib_grid_columns_by_rowheightIf 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_fontA string value. The font name. Default: Arial.
il_header_font_familyA long value. The font family. 0 - AnyFont, 1 - Roman, 2 - Swiss, 3 - Modern, 4 - Script, 5 - Decorative. Default: 0.
il_header_font_charsetA long value. The font charset. 0 - Ansi, 1 - default, 2 - Symbol, 128 - Shift JIS, 255 - OEM. Default: 0.
il_header_fg_colorA long value. The foreground color. Use RGB(). Default: Black
il_header_bg_colorA long value. The background color. Use RGB(). Default: White
is_header_text_alignA string value. The alignment of the text inside the header cell ("center"|"left"|"right"). Default: center.
is_header_alignA string value. The alignment of the header cell inside the page ("center"|"left"|"right"). Default: left.
il_header_font_sizeA long value. The font size. Default: 10.
ib_header_font_boldA boolean value. The font is bold. Default: True
ib_header_font_underlineA boolean value. The font is underlined. Default: False.
ib_header_font_italicA boolean value. The font is italic. Default: False.
il_header_heightA long value. The height of header cell (DW units).Default: 100.
il_header_widthA long value. The width of header cell (DW units).Default: 2800.
il_header_separator_heightA long value. The height of empty row separating the header from the rest of data. Default: 0.