EMS logo

Products Navigation

Advanced Data Export .NET

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

Advanced Data Export .NET

On-line Documentation

QExportXLS.StripStyles


 

public SqlManager.QExport.XLS.XlsStripStyles StripStyles {get; set;}

 

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[0].Fill.Background = clrPaleBlue;

StripStyles[0].Fill.Pattern = ptSolid;

StripStyles[1].Fill.Background = clrLightTurquoise;

StripStyles[1].Fill.Pattern = ptSolid;

 

StripType == ssCol.

 

StripType == ssRow.

 

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

 

 

See also:

QExportXLS

QExportXLS Properties

QExportXLS Methods

QExportXLS Events