Create and Delete Tables

Spread.Services Documentation
Create and Delete Tables
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Manage Data in Spread Component > Use Table > Create and Delete Tables

In Spread.Services, you can create and delete tables in spreadsheets using the Add method of the ITables interface and the Delete Method of the ITable Interface, or simply transform a cell range into a table by specifying the existing data lying in a worksheet.

Refer to the following example code to create and delete tables in a worksheet.

C# | Copy Code
--- | ---

    //Create workbook and access its first worksheet
    Workbook workbook = new Workbook();
    IWorksheet worksheet = workbook.Worksheets[0];
    //Add first table
    ITable table1 = worksheet.Tables.Add(worksheet.Range["A1:E5"], true);
    //Add second table
    ITable table2 = worksheet.Tables.Add(worksheet.Range["F1:G5"], true);
    //Delete second Table
    worksheet.Tables[1].Delete();

Copyright © GrapeCity, inc. All rights reserved.