Online Documentation for SQL Manager for Oracle

MS Excel / ODS options

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


Using the Base Styles tab you can set font and border options for all elements of the Excel / 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 / 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 iconPlus Plus button.

To delete a style template, select it and click the iconMinus Minus 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 / 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.