IListObject ShowTableStyleRowStripes Property |
<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