Online Documentation for Data Export for SQL Server

Advanced


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

 

Format-specific options - MS Excel - Advanced

 

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.

 

CheckBox 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.