Table.ConvertToRange() Method

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

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

void ConvertToRange()

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.

See Also

Spreadsheet Tables

Table Interface

Table Members

DevExpress.Spreadsheet Namespace