EMS logo

Products Navigation

Data Export for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Export for SQL Server

On-line Documentation

Styles


Using the Styles tab you can make a style template: set font options, border and fill options and save them.

 

Use iconPlus iconMinus buttons to add/remove a style.

Use btnMoveUp btnMoveDown buttons to reorder the style's list.

You can also save styles and load saved ones.

 

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 style selection).

 

Format-specific options - MS Excel - Data format - Styles

 

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

 

The Font tab allows you to specify properties of the font that will be used in the output Excel file cells.

 

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

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

 

Format-specific options - MS Excel - Data format - Options - Font

 

The Borders tab allows you to specify properties of the borders of the output Excel file cells.

 

Press the btnExportData_TopBorder btnExportData_BottomBorder btnExportData_LeftBorder btnExportData_RightBorder buttons on the left to show/hide the borders they indicate.

Use the drop-down list for each border to select the line type and the btnExportData_ForegroundColor button on the right to select the line color for each border.

 

Format-specific options - MS Excel - Data format - Options - Borders

 

The Fill tab allows you to specify the fill pattern for the output Excel file cells.

 

Use the drop-down list to select the preferable fill pattern type.

Press the btnExportData_BackgroundColor button on the left to set the background color for the fill pattern.

Press the btnExportData_ForegroundColor button on the right to set the foreground color for the fill pattern.

 

Format-specific options - MS Excel - Data format - Options - Fill

 

At the Sample Cell section you can preview options changes.