Click or drag to resize

IListObject ShowTableStyleColumnStripes Property

Gets or sets a value indicating whether column stripes should be present.
Examples
The following code illustrates how to set ShowTableStyleRowStripes to "False" and set ShowTableStyleColumnStripes to "True" to change the default formatting of the table:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create table</para><para>IListObject table1 = worksheet.ListObjects.Create("Table1", worksheet["A1:C6"]);</para><para>//Set Row Column Stripe Visiblity</para><para>table1.ShowTableStyleRowStripes = false;</para><para>table1.ShowTableStyleColumnStripes = true;</para><para>//Apply builtin style</para><para>table1.BuiltInTableStyle = TableBuiltInStyles.TableStyleMedium9;</para><para>//Create style for table number format</para><para>IStyle style1 = workbook.Styles.Add("CurrencyFormat");</para><para>style1.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* \" - \"??_);_(@_)";</para><para>//Apply number format</para><para>worksheet["B2:C6"].CellStyleName = "CurrencyFormat";</para><para>//Save to file</para><para>workbook.SaveToFile("Table.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
bool ShowTableStyleColumnStripes { get; set; }

Property Value

Type: Boolean
See Also