Online Documentation for Advanced Data Export .NET



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



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.