EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

MS Excel 2007 / ODS options

This step allows you to set options for the target MS Excel 2007 (*.xlsx) or ODF Spreadsheets (*.ods) file.


Using the Base Styles tab you can set font and border options for all elements of the Excel 2007 / ODS sheet (HEADER, CAPTION, DATA, FOOTER). You can customize style options, such as font and size, background and foreground colors, text alignment, etc. for each of them by clicking the corresponding item in the list and setting the options in the right-side panel.


If necessary, you can also specify the sheet name for the target Excel 2007 / ODS file.


Use the Font and Size drop-down lists to select the font and size to be applied to the text.

Use the buttons below to set font color, make text bold, italicized, underlined, specify horizontal and vertical align.


CheckBox Background

Enables/disables background for text.

Press the btnExportData_BackgroundColor button to set the background color for the text.

Press the Wrap Text button to enable/disable the text wrapping feature.


For your convenience the previews illustrating the changes are displayed in the Sample Group area within the Base Styles and the Strip Styles tabs.


Export Data - Format-specific options - Excel 2007 - Base Styles



Using the Strip Styles tab you can create a style template: set font, size, background color, text alignment, wrap text options and save them.


To add a style template, click the Plus iconPlus button.

To delete a style template, select it and click the Minus iconMinus button.

To reorder style templates in the list, use the btnMoveItemUp btnMoveItemDown buttons.

To load a style template, click the iconLoadFromFile button.

To save the current style template, click the btnSave button.


If you have created or loaded more than one style template, they can be ignored, or used column-by-column or row-by-row (it depends on the Strip type selection).


Export Data - Format-specific options - Excel 2007 - Strip Styles



You can reset the changes any time using the Reset Item and the Reset All buttons.



The Border tab allows you to specify properties of the borders of the output Excel 2007 / ODS file cells.


CheckBox Use border

Enables/disables borders in the output file.

Press the btnExportData_Color button to set the color to be applied to the borders.

Use the Border Style drop-down list to select the preferable style that will be used for borders (thin, dashed, dashdot, dotted, etc.).


Export Data - Format-specific options - Excel 2007 - Border



When you are done, click the Next button to proceed to Setting common export options.