Online Documentation for SQL Manager for DB2

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.

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

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

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