[DefaultMember("Item")]

public class TableColumnCollection : 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[ 6 ].Value = "Fruits";

    worksheetA.Rows[ 5 ].Cells[ 6 ].Value = "Strawberry";

    worksheetA.Rows[ 6 ].Cells[ 6 ].Value = "Orange";

    worksheetA.Rows[ 7 ].Cells[ 6 ].Value = "Banana";

    worksheetA.Rows[ 8 ].Cells[ 6 ].Value = "Apple";

    worksheetA.Rows[ 4 ].Cells[ 7 ].Value = "Quantity";

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

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

    worksheetA.Rows[ 7 ].Cells[ 7 ].Value = 3;

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



    // Creates the formatted table from cell (4,6) to cell (8,7), using a medium theme, with the formatted header row displayed.

    worksheetA.Tables.Add( 4, 6, 8, 7, TableStyle.TableStyleMedium20, true );



    // Gets the first table of the Worksheet.

    var firstTable = worksheetA.Tables[ “Table1” ];



    // Sets a TotalRowLabel on the first column of the Table. 

    firstTable.Columns[ 0 ].TotalRowLabel = "TOTAL:";



    doc.Save();

  }