Enumeration: TableRemoveOptions

Sheets.Tables.TableRemoveOptions

Specifies how to remove the table, whether keep data and style.

example

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");
//button click
$("#button1").click(function () {
     var table  = activeSheet.tables.find(0,0);
     activeSheet.tables.remove(table, GC.Spread.Sheets.Tables.TableRemoveOptions.keepData);
});

Table of contents

Enumeration members

• keepData
• keepStyle
• none

Enumeration members

keepData

• keepData = 1

Remove table, keep table data.

keepStyle

• keepStyle = 2

Remove table, keep table style.

none

• none = 0

Remove table, keep nothing.