Click or drag to resize

IListObject ShowTableStyleRowStripes Property

Gets or sets a value indicating whether row stripes should be present.
Examples
The following code illustrates how to set ShowTableStyleRowStripes to "False" and set ShowTableStyleColumnStripes to "True" to enable table formatting in columns only:
<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 ShowTableStyleRowStripes { get; set; }

Property Value

Type: Boolean
See Also