TableCollection.Clear() Method

Removes all tables from the worksheet.

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp

void Clear()

Sub Clear

The Clear method removes all objects from the Worksheet.Tables collection, and deletes data and formatting from worksheet cells. To remove an individual table from the collection, use the TableCollection.Remove, TableCollection.RemoveAt or Table.Delete method.

If you need to delete a table, but leave its data in a regular cell range and convert table formatting to cell direct formatting, use the Table.ConvertToRange method.

To create a table, use the TableCollection.Add method (see the How to: Create a Table example).