Online Documentation for Data Export for MySQL
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.
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.