Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TableCollection.Clear() Method

In This Article

Removes all tables from the worksheet.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

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

See Also