Table.ConvertToRange() Method

Converts the table to a regular range of cells without losing data and formatting.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

void ConvertToRange()

VB.NET

Sub ConvertToRange

Remarks

The ConvertToRange method deletes the Table object from the collection, but leaves data in cells, replaces structured references with regular absolute references and converts table style formatting to cell direct formatting.

To delete a table completely (including data and formatting), use the Table.Delete, TableCollection.Remove or TableCollection.RemoveAt methods. To remove all tables from the worksheet, use the TableCollection.Clear method.