Convert an Excel Table to a Range of Data

Convert an Excel Table to a Range of Data

Aspose.Cells for Python via Java provides the option to convert Excel Table to a range of data. For this, the API provides the ListObject.convertToRange method. The following code snippet demonstrates the use of ListObject.convertToRange method to convert an Excel table to a range of data.

Convert an Excel Table to a Range with Options

You may provide additional options while converting a table to a range with the TableToRangeOptions class. You may pass an instance of the TableToRangeOptions class to the ListObject.convertToRange method to specify additional options. The following code snippet demonstrates the use of the TableToRangeOptions class to set the last row index of the table. The table formatting will be retained up to the specified row index and the rest of the formatting will be removed.