Enum TableStyleElementType

TableStyleElementType enumeration

Represents the Table or PivotTable style element type.

public enum TableStyleElementType

Values

NameValueDescription
BlankRow18Table style element that applies to PivotTable’s blank rows.
FirstColumn8Table style element that applies to table’s first column.
FirstColumnStripe3Table style element that applies to table’s first column stripes.
FirstColumnSubheading22Table style element that applies to PivotTable’s first column subheading.
FirstHeaderCell11Table style element that applies to table’s first header row cell.
FirstRowStripe5Table style element that applies to table’s first row stripes.
FirstRowSubheading25Table style element that applies to PivotTable’s first row subheading.
FirstSubtotalColumn15Table style element that applies to PivotTable’s first subtotal column.
FirstSubtotalRow19Table style element that applies to pivot table’s first subtotal row.
GrandTotalColumn28Table style element that applies to pivot table’s grand total column.
GrandTotalRow29Table style element that applies to pivot table’s grand total row.
FirstTotalCell13Table style element that applies to table’s first total row cell.
HeaderRow9Table style element that applies to table’s header row.
LastColumn7Table style element that applies to table’s last column.
LastHeaderCell12Table style element that applies to table’s last header row cell.
LastTotalCell14Table style element that applies to table’s last total row cell.
PageFieldLabels1Table style element that applies to pivot table’s page field labels.
PageFieldValues2Table style element that applies to pivot table’s page field values.
SecondColumnStripe4Table style element that applies to table’s second column stripes.
SecondColumnSubheading23Table style element that applies to pivot table’s second column subheading.
SecondRowStripe6Table style element that applies to table’s second row stripes.
SecondRowSubheading26Table style element that applies to pivot table’s second row subheading.
SecondSubtotalColumn16Table style element that applies to PivotTable’s second subtotal column.
SecondSubtotalRow20Table style element that applies to PivotTable’s second subtotal row.
ThirdColumnSubheading24Table style element that applies to PivotTable’s third column subheading.
ThirdRowSubheading27Table style element that applies to PivotTable’s third row subheading.
ThirdSubtotalColumn17Table style element that applies to pivot table’s third subtotal column.
ThirdSubtotalRow21Table style element that applies to PivotTable’s third subtotal row.
TotalRow10Table style element that applies to table’s total row.
WholeTable0Table style element that applies to table’s entire content.

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.Tables;

namespace AsposeCellsExamples
{
    public class TablesClassTableStyleElementTypeDemo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            
            Style firstColumnStyle = workbook.CreateStyle();
            firstColumnStyle.Pattern = BackgroundType.Solid;
            firstColumnStyle.ForegroundColor = System.Drawing.Color.LightBlue;
            
            Style lastColumnStyle = workbook.CreateStyle();
            lastColumnStyle.Font.IsBold = true;
            lastColumnStyle.Pattern = BackgroundType.Solid;
            lastColumnStyle.ForegroundColor = System.Drawing.Color.LightGreen;

            string tableStyleName = "CustomStyle1";
            TableStyleCollection tableStyles = workbook.Worksheets.TableStyles;
            int styleIndex = tableStyles.AddTableStyle(tableStyleName);
            TableStyle tableStyle = tableStyles[styleIndex];

            TableStyleElementCollection elements = tableStyle.TableStyleElements;
            
            int elementIndex = elements.Add(TableStyleElementType.FirstColumn);
            elements[elementIndex].SetElementStyle(firstColumnStyle);
            
            elementIndex = elements.Add(TableStyleElementType.LastColumn);
            elements[elementIndex].SetElementStyle(lastColumnStyle);

            Cells cells = workbook.Worksheets[0].Cells;
            for (int i = 0; i < 5; i++)
            {
                cells[0, i].PutValue($"Column {i + 1}");
            }

            for (int row = 1; row < 5; row++)
            {
                for (int col = 0; col < 5; col++)
                {
                    cells[row, col].PutValue(row * col);
                }
            }

            ListObject table = workbook.Worksheets[0].ListObjects[workbook.Worksheets[0].ListObjects.Add(0, 0, 4, 4, true)];
            table.ShowTableStyleFirstColumn = true;
            table.ShowTableStyleLastColumn = true;
            table.TableStyleName = tableStyleName;

            workbook.Save("TableStyleDemo.xlsx");
        }
    }
}

See Also