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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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	Description
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)

UWP- v19.1.0.63

Interface ITableStyleElement

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.UWP.dll

Syntax

Properties

BackColor

Declaration

Property Value

Examples

BackColorRGB

Declaration

Property Value

Examples

Bold

Declaration

Property Value

Examples

BottomBorderColor

Declaration

Property Value

Examples

BottomBorderColorRGB

Declaration

Property Value

Examples

BottomBorderStyle

Declaration

Property Value

Examples

FontColor

Declaration

Property Value

Examples

FontColorRGB

Declaration

Property Value

Examples

HorizontalBorderColor

Declaration

Property Value

Examples

HorizontalBorderColorRGB

Declaration

Property Value

Examples

HorizontalBorderStyle

Declaration

Property Value

Examples

Italic

Declaration

Property Value

Examples

LeftBorderColor

Declaration

Property Value

Examples

LeftBorderColorRGB

Declaration

Property Value

Examples

LeftBorderStyle

Declaration

Property Value

Examples

PatternColor

Declaration

Property Value

Examples

PatternColorRGB

Declaration

Property Value

Examples

PatternStyle

Declaration

Property Value

Examples

RightBorderColor

Declaration