Online Documentation for Data Export for SQL Server

Data format

The Data Format tab contains general options which allow you to adjust the format for each kind of Excel cells. This means that you can specify such parameters as font, borders, filling color and method, etc. for each entity (such as data field, header, footer, caption, data, hyperlink and so on) separately. Also it is possible to create styles to make the target Excel file striped by columns or rows.
 

• Columns
• Options
• Styles

 
Note: For your convenience the previews illustrating the changes are displayed in the Sample Cell area on each sub-tab of the Data Format tab.