Click or drag to resize

IWorksheet SetDefaultRowStyle Method (Int32, Int32, IStyle)

Sets by column index default style for row.
Examples
The following code illustrates how to set the default style for rows:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create style</para><para>CellStyle style = workbook.Styles.Add("CustomStyle");</para><para>//Set Color</para><para>style.Color = Color.Red;</para><para>//Set default style</para><para>worksheet.SetDefaultRowStyle(2, 5, style);</para><para>//Save to file</para><para>workbook.SaveToFile("SetDefaultRowStyle.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
void SetDefaultRowStyle(
	int iStartRowIndex,
	int iEndRowIndex,
	IStyle defaultStyle
)

Parameters

iStartRowIndex
Type: System Int32
Start row index.
iEndRowIndex
Type: System Int32
End row index.
defaultStyle
Type: Spire.Xls.Core IStyle
Default style.
See Also