Spread.Sheets Documentation
remove Method
The table instance or the table name.
Specifies what data is kept when removing the table.
Removes a specified table.
Syntax
var instance = new GC.Spread.Sheets.Tables.TableManager(sheet);
var value; // Type: any
value = instance.remove(table, options);
function remove( 
   table : undefined,
   options : TableRemoveOptions
) : any;

Parameters

table
The table instance or the table name.
options
Specifies what data is kept when removing the table.
Example
This example removes the table.
activeSheet.tables.add("Table1", 0, 0, 3, 3, GC.Spread.Sheets.Tables.TableThemes.dark1);
activeSheet.getCell(0,0).text("Name");
activeSheet.getCell(0,1).text("Value");
activeSheet.getCell(0,2).text("T/F");
activeSheet.getCell(1,0).text("AW");
activeSheet.getCell(1,1).text("5");
activeSheet.getCell(1,2).text("T");

$("#button1").click(function () {
var table  = activeSheet.tables.find(0,0);
activeSheet.tables.remove(table, GC.Spread.Sheets.Tables.TableRemoveOptions.keepData);
    });

...
<input type="button" id="button1" value="Button 1" />
activeSheet.tables.add("Table1", 0, 0, 3, 3, GC.Spread.Sheets.Tables.TableThemes.dark1);
activeSheet.getCell(0,0).text("Name");
activeSheet.getCell(0,1).text("Value");
activeSheet.getCell(0,2).text("T/F");
activeSheet.getCell(1,0).text("AW");
activeSheet.getCell(1,1).text("5");
activeSheet.getCell(1,2).text("T");

$("#button1").click(function () {
var table  = activeSheet.tables.find(0,0);
activeSheet.tables.remove(table);
    });
See Also

Reference

TableManager type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.