TableCollection.Clear() Method

Removes all tables from the worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Clear()

VB.NET

Sub Clear

Remarks

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).