Online Documentation for SQL Manager for DB2

Advanced


The Advanced tab allows you to set a number of advanced options to be applied to the result MS Excel file.

 

Page header

If necessary, enter some text for the page header.

 

Page footer

If necessary, enter some text for the page footer.

 

Hint: It is also possible to set macros in the Page header and Page footer fields:

&N stands for the quantity of pages;

&P - the number of the current page.

 

Sheet title

Specify the sheet title for the target file.

 

Page background

If necessary, use the Ellipsis EllipsisButton button to browse for a graphical file to be applied as the page background.

 

Export Data - Format-specific options - Excel - Advanced

 

 

CheckBox Calculate column width automatically

This option allows the wizard to determine column width in the target file automatically according to column size.