menu

UWP

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface ITableStyleElement - UWP API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface ITableStyleElement

    Represents Table Style Element

    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.UWP.dll
    Syntax
    public interface ITableStyleElement

    Properties

    BackColor

    Gets or sets the background color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors BackColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.BackColor=ExcelKnownColors.Blue;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    BackColorRGB

    Gets and sets the back ground RGB color.

    Declaration
    Color BackColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.BackColorRGB = System.Drawing.Color.FromArgb(255, 255, 0, 0);
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    Bold

    Gets or sets a boolean value indicating whether the font is bold.

    Declaration
    bool Bold { get; set; }
    Property Value
    Type
    System.Boolean
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.Bold = true;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    BottomBorderColor

    Gets or sets the bottom border color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors BottomBorderColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.BottomBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.BottomBorderColor=ExcelKnownColors.Green;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    BottomBorderColorRGB

    Gets or sets RGB color to bottom border.

    Declaration
    Color BottomBorderColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.BottomBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.BottomBorderColorRGB = System.Drawing.Color.FromArgb(255, 0, 255, 0);
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    BottomBorderStyle

    Gets or sets the bottom border line style.

    Declaration
    ExcelLineStyle BottomBorderStyle { get; set; }
    Property Value
    Type
    ExcelLineStyle
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.BottomBorderStyle=ExcelLineStyle.Thick;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    FontColor

    Gets or sets the Font color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors FontColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.FontColor=ExcelKnownColors.Red;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    FontColorRGB

    Gets or sets RGB color to font.

    Declaration
    Color FontColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.FontColorRGB=System.Drawing.Color.FromArgb(255, 0, 0, 255);
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    HorizontalBorderColor

    Gets or sets the Horizontal Border color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors HorizontalBorderColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.HorizontalBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.HorizontalBorderColor=ExcelKnownColors.Green;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    HorizontalBorderColorRGB

    Gets or sets RGB color to horizontal border.

    Declaration
    Color HorizontalBorderColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.HorizontalBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.HorizontalBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    HorizontalBorderStyle

    Gets or sets the Horizontal border line style.

    Declaration
    ExcelLineStyle HorizontalBorderStyle { get; set; }
    Property Value
    Type
    ExcelLineStyle
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.HorizontalBorderStyle = ExcelLineStyle.Thick;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    Italic

    Gets or sets a boolean value indicating whether the font is italic.

    Declaration
    bool Italic { get; set; }
    Property Value
    Type
    System.Boolean
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.Italic = true;
          workbook.SaveAs("CustomTableStyle.xlsx");
    
          workbook.Close();
    }

    LeftBorderColor

    Gets or sets the left border color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors LeftBorderColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.LeftBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.LeftBorderColor=ExcelKnownColors.Green;
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    LeftBorderColorRGB

    Gets or sets RGB color to left border.

    Declaration
    Color LeftBorderColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.LeftBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.LeftBorderColorRGB = System.Drawing.Color.FromArgb(255, 0, 255, 0);
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    LeftBorderStyle

    Gets or sets the left border line style.

    Declaration
    ExcelLineStyle LeftBorderStyle { get; set; }
    Property Value
    Type
    ExcelLineStyle
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.LeftBorderStyle=ExcelLineStyle.Thick;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    PatternColor

    Gets or sets the pattern color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors PatternColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.PatternStyle = ExcelPattern.DarkVertical;
          tableStyleElement.PatternColor = ExcelKnownColors.Green;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    PatternColorRGB

    Gets or sets RGB color to pattern.

    Declaration
    Color PatternColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.PatternStyle = ExcelPattern.DarkVertical;
          tableStyleElement.PatternColorRGB = System.Drawing.Color.FromArgb(255, 255, 0, 0);
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    PatternStyle

    Gets and sets the pattern style from table style element.

    Declaration
    ExcelPattern PatternStyle { get; set; }
    Property Value
    Type
    ExcelPattern
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.PatternStyle=ExcelPattern.DarkVertical;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    RightBorderColor

    Gets or sets the right border color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors RightBorderColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.RightBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.RightBorderColor=ExcelKnownColors.Green;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    RightBorderColorRGB

    Gets or sets RGB color to right border.

    Declaration
    Color RightBorderColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.RightBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.RightBorderColorRGB = System.Drawing.Color.FromArgb(255, 0, 255, 0);
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    RightBorderStyle

    Gets or sets the right border line style.

    Declaration
    ExcelLineStyle RightBorderStyle { get; set; }
    Property Value
    Type
    ExcelLineStyle
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.RightBorderStyle=ExcelLineStyle.Thick;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    StrikeThrough

    Gets or sets a boolean value indicating whether the font is Strike.

    Declaration
    bool StrikeThrough { get; set; }
    Property Value
    Type
    System.Boolean
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.StrikeThrough=true;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    StripeSize

    Gets or sets the table style element row and column strip size.

    Declaration
    int StripeSize { get; set; }
    Property Value
    Type
    System.Int32
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumnStripe);
          tableStyleElement.BackColor = ExcelKnownColors.Blue;
          tableStyleElement.StripeSize = 2;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    TableStyleElementType

    Gets the table style element type from related table style element.

    Declaration
    ExcelTableStyleElementType TableStyleElementType { get; }
    Property Value
    Type
    ExcelTableStyleElementType
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          ExcelTableStyleElementType tableStyleElementType= tableStyleElements[0].TableStyleElementType;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    TopBorderColor

    Gets or sets the Top Border color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors TopBorderColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.TopBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.TopBorderColor=ExcelKnownColors.Green;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    TopBorderColorRGB

    Gets or sets RGB color to Top border.

    Declaration
    Color TopBorderColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.TopBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.TopBorderColorRGB=System.Drawing.Color.FromArgb(255, 0, 255, 0);
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    TopBorderStyle

    Gets or sets the Top border line style.

    Declaration
    ExcelLineStyle TopBorderStyle { get; set; }
    Property Value
    Type
    ExcelLineStyle
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.TopBorderStyle=ExcelLineStyle.Thick;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    Underline

    Gets or sets the underline type from the table style element.

    Declaration
    ExcelUnderline Underline { get; set; }
    Property Value
    Type
    ExcelUnderline
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.Underline =ExcelUnderline.Single;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    VerticalBorderColor

    Gets or sets the Vertical Border color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors VerticalBorderColor { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.VerticalBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.VerticalBorderColor=ExcelKnownColors.Green;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    VerticalBorderColorRGB

    Gets or sets RGB color to Vertical border.

    Declaration
    Color VerticalBorderColorRGB { get; set; }
    Property Value
    Type
    Windows.UI.Color
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.VerticalBorderStyle=ExcelLineStyle.Thick;
          tableStyleElement.VerticalBorderColorRGB = System.Drawing.Color.FromArgb(255, 0, 255, 0);
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    VerticalBorderStyle

    Gets or sets the Vertical border line style.

    Declaration
    ExcelLineStyle VerticalBorderStyle { get; set; }
    Property Value
    Type
    ExcelLineStyle
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
        {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.VerticalBorderStyle = ExcelLineStyle.Thick;
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    Methods

    Clear()

    Delete the table style element from table style elements list collection.

    Declaration
    void Clear()
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.LeftBorderStyle=ExcelLineStyle.Thin;
          tableStyleElement.LeftBorderColor=ExcelKnownColors.Red;
          tableStyleElement.BackColor=ExcelKnownColors.Blue;
          tableStyleElement.Clear();
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    Clone()

    Clone the table style element and return.

    Declaration
    ITableStyleElement Clone()
    Returns
    Type
    ITableStyleElement
    Examples
    using(ExcelEngine excelEngine = new ExcelEngine())
    {
          IApplication application = excelEngine.Excel;
          IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
          IWorksheet worksheet = workbook.Worksheets[0];
    
          string name = "Table Style 4";
          ITableStyles tableStyles = workbook.TableStyles;
          ITableStyle tableStyle = tableStyles.Add(name);
          ITableStyleElements tableStyleElements = tableStyle.TableStyleElements;
          ITableStyleElement tableStyleElement = tableStyleElements.Add(ExcelTableStyleElementType.FirstColumn);
          tableStyleElement.LeftBorderStyle=ExcelLineStyle.Thin;
          tableStyleElement.LeftBorderColor=ExcelKnownColors.Red;
          tableStyleElement.BackColor=ExcelKnownColors.Blue;
          ITableStyleElement tableStyleElementClone = tableStyleElement.Clone();
    
          workbook.SaveAs("CustomTableStyle.xlsx");
          workbook.Close();
    }

    Extension Methods

    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved