EMS logo

Products Navigation

Advanced Data Export VCL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Advanced Data Export VCL

On-line Documentation

TQExport4XLS.StripStyles

 

TQExport4XLS                                


 

property StripStyle: TxlsFormats;

 

Description

Use StripStyles do define repeating styles for columns or rows of the result sheet. StripStyle determines font size, color and other attributes, border and fill styles and more. To apply this styles to columns or rows use property StripType.

 

The pictures below show the examples of the result Excel sheet with two styles applied.

 

The styles were defined in the following way:

StripStyles.Items[0].Fill.Background = clrPaleBlue;

StripStyles.Items[0].Fill.Pattern = ptSolid;

StripStyles.Items[1].Fill.Background = clrLightTurquoise;

StripStyles.Items[1].Fill.Pattern = ptSolid;

 

StripType = ssCol.

 

StripType = ssRow.

 

 

Note: The StripStyles property has a higher priority than the FieldFormats property. If the StripStyles property is defined and the StripTypeproperty is set to ssCol or ssRow, all the field styles defined in the FieldFormats property takes no effect.

 

 


See also:

StripType property