**EPPlus provides approximately 60 different built in Table styles.  
These are defined in the [*OfficeOpenXml.TableStyles*](<https://github.com/EPPlusSoftware/EPPlus/blob/develop/src/EPPlus/Table/enums/TableStyles.cs>) enum.  
The table styles defines background colors, borders, etc for the various elements of a table.  
This program below generates a workbook where you can see all these table styles - run the program once and then you can explore the different table styles in the workbook.**

The program is a console program that needs to have a reference to the EPPlus nuget package.

```csharp
using OfficeOpenXml;
using OfficeOpenXml.Table;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;

namespace AllTableStyles
{
    class Program
    {
        // this is the path of the generated workbook. Change it to whatever you like.
        const string FilePath = @"c:\Temp\AllTableStyles.xlsx";

        static IEnumerable<TableStyles> GetTableStyles()
        {
            return Enum.GetValues(typeof(TableStyles)).Cast<TableStyles>();
        }

        static void PrintTable(ExcelWorksheet worksheet, int row, int col, TableStyles style)
        {
            var table = worksheet.Tables.Add(worksheet.Cells[row, col, row + 4, col + 3], "");
            // here you can test to change some other properties of the table, such as:
            //table.ShowFirstColumn = true;
            //table.ShowRowStripes = true;
            table.TableStyle = style;

            var c1 = table.Columns.Count();
            c1++;
            var range = table.Columns.Add(1);
            for(var ix = range.Start.Row; ix < range.End.Row; ix++)
            {
                worksheet.SetValue(ix, c1, "abc");
            }

            for(var c = table.Range.Start.Column; c < table.Range.End.Column; c++)
            {
                for (var r = table.Range.Start.Row + 1; r < table.Range.End.Row;  r++)
                {
                    worksheet.Cells[r, c].Value = c + r;
                }
            }
        }

        static void Main(string[] args)
        {
            ExcelPackage.LicenseContext = LicenseContext.Commercial;
            // Or if you are using EPPlus in a NonCommercial context:
            // ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
            using(var package = new ExcelPackage(new FileInfo(FilePath)))
            {
                var ws = package.Workbook.Worksheets.Add("All styles");
                var row = 1;
                var col = 1;
                var i = 0;
                var styles = GetTableStyles();
                foreach (var style in styles)
                {
                    ws.Cells[row, col].Value = style.ToString();
                    ws.Cells[row, col].Style.Font.Bold = true;
                    PrintTable(ws, row + 1, col, style);
                    if(++i % 3 == 0)
                    {
                        row += 7;
                        col = 1;
                    }
                    else
                    {
                        col += 6;
                    }
                }
                package.Save();
            }
            Console.WriteLine("Done!");
            Console.ReadKey();
        }
    }
}
```

```vbnet
Imports OfficeOpenXml
Imports OfficeOpenXml.Table
Imports System
Imports System.Collections.Generic
Imports System.IO
Imports System.Linq

Namespace AllTableStyles
    Friend Class Program
        ' this is the path of the generated workbook. Change it to whatever you like.
        Const FilePath As String = "c:\Temp\AllTableStyles.xlsx"

        Private Shared Function GetTableStyles() As IEnumerable(Of TableStyles)
            Return [Enum].GetValues(GetType(TableStyles)).Cast(Of TableStyles)()
        End Function

        Private Shared Sub PrintTable(worksheet As ExcelWorksheet, row As Integer, col As Integer, style As TableStyles)
            Dim table = worksheet.Tables.Add(worksheet.Cells(row, col, row + 4, col + 3), "")
            ' here you can test to change some other properties of the table, such as:
            'table.ShowFirstColumn = true;
            'table.ShowRowStripes = true;
            table.TableStyle = style

            Dim c1 = table.Columns.Count()
            c1 += 1
            Dim range = table.Columns.Add(1)
            For ix As Integer = range.Start.Row To range.End.Row - 1
                worksheet.SetValue(ix, c1, "abc")
            Next

            For c As Integer = table.Range.Start.Column To table.Range.End.Column - 1
                For r As Integer = table.Range.Start.Row + 1 To table.Range.End.Row - 1
                    worksheet.Cells(r, c).Value = c + r
                Next
            Next
        End Sub

        Shared Sub Main(args As String())
            ExcelPackage.LicenseContext = LicenseContext.Commercial
            ' Or if you are using EPPlus in a NonCommercial context:
            ' ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
            Using package As New ExcelPackage(New FileInfo(FilePath))
                Dim ws = package.Workbook.Worksheets.Add("All styles")
                Dim row = 1
                Dim col = 1
                Dim i = 0
                Dim styles = GetTableStyles()
                For Each style In styles
                    ws.Cells(row, col).Value = style.ToString()
                    ws.Cells(row, col).Style.Font.Bold = True
                    PrintTable(ws, row + 1, col, style)
                    i += 1
                    If i Mod 3 = 0 Then
                        row += 7
                        col = 1
                    Else
                        col += 6
                    End If
                Next
                package.Save()
            End Using
            Console.WriteLine("Done!")
            Console.ReadKey()
        End Sub
    End Class
End Namespace
```

### See also

- [Tables](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/index.md>)