Online Documentation for Data Export for PostgreSQL
The Advanced tab allows you to set a number of advanced options to be applied to the result MS Excel file.
If necessary, enter some text for the page header.
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.
Specify the sheet title for the target file.
Split by rows
Use this field to define the number of rows on each sheet.
Automatic column width
Enable this option if you want each column of the target file to be adjusted to the maximum number of characters in it.