public class TableColumn : WorksheetElement 

using( var doc = Workbook.Create( "test.xlsx") )   // Creates a Workbook named “test.xlsx”.

  {

    var worksheetA = workbook.Worksheets[ 0 ];



    // Fill cells values.

    worksheetA.Rows[ 4 ].Cells[ 10 ].Value = "Employee";

    worksheetA.Rows[ 5 ].Cells[ 10 ].Value = "Nancy Davolio";

    worksheetA.Rows[ 6 ].Cells[ 10 ].Value = "Margaret Peacock";

    worksheetA.Rows[ 7 ].Cells[ 10 ].Value = "Steven Buchanan";

    worksheetA.Rows[ 8 ].Cells[ 10 ].Value = "Laura Callahan";

    worksheetA.Rows[ 4 ].Cells[ 11 ].Value = "Years of experience";

    worksheetA.Rows[ 5 ].Cells[ 11 ].Value = 12;

    worksheetA.Rows[ 6 ].Cells[ 11 ].Value = 2;

    worksheetA.Rows[ 7 ].Cells[ 11 ].Value = 9;

    worksheetA.Rows[ 8 ].Cells[ 11 ].Value = 7;

    worksheetA.Rows[ 4 ].Cells[ 12 ].Value = "Salary";

    worksheetA.Rows[ 5 ].Cells[ 12 ].Value = 75000;

    worksheetA.Rows[ 6 ].Cells[ 12 ].Value = 41000;

    worksheetA.Rows[ 7 ].Cells[ 12 ].Value = 64000;

    worksheetA.Rows[ 8 ].Cells[ 12 ].Value = 55000;



    // Creates the formatted table from cell (4,10) to cell (8,12), using a light theme, with the formatted header row displayed.

    worksheetA.Tables.Add( 4, 10, 8, 12, TableStyle.TableStyleLight14, true );



    // Gets this formatted table and sets some properties. Table and TableColumn can be accessed by position or name. 

    worksheetA.Tables[ "Table1" ].ShowTotalRow = true;

    worksheetA.Tables[ "Table1" ].Columns[ "Employee" ].TotalRowLabel = "Avg:";

    worksheetA.Tables[ "Table1" ].Columns[ "Years of experience" ].TotalRowFunction = TotalRowFunction.Average;

    worksheetA.Tables[ "Table1" ].Columns[ "Salary" ].TotalRowFunction = TotalRowFunction.CustomFormula;

    worksheetA.Tables[ "Table1" ].Columns[ "Salary" ].TotalRowFormula = "=AVERAGE(M6:M9)";

        

    doc.Save();

  }