Click or drag to resize

IWorksheet SetDefaultColumnStyle Method (Int32, Int32, IStyle)

Sets by column index default style for column.
Examples
The following code illustrates how to set the default style for columns:
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.SetDefaultColumnStyle(2, 5, style);</para><para>//Save to file</para><para>workbook.SaveToFile("SetDefaultColumnStyle.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 SetDefaultColumnStyle(
	int iStartColumnIndex,
	int iEndColumnIndex,
	IStyle defaultStyle
)

Parameters

iStartColumnIndex
Type: System Int32
Start column index.
iEndColumnIndex
Type: System Int32
End column index.
defaultStyle
Type: Spire.Xls.Core IStyle
Default style.
See Also