将 Excel 表转换为数据范围

Aspose.Cells for Python via Java 提供将 Excel 表格转换为一系列数据的选项。为此，API 提供了[ListObject.convertToRange](https://reference.aspose.com/cells/python/asposecells.api/listobject#convertToRange() ）方法。下面的代码片段演示了使用[ListObject.convertToRange](https://reference.aspose.com/cells/python/asposecells.api/listobject#convertToRange()方法将 Excel 表格转换为一系列数据。

	source_directory = "Examples/SampleFiles/SourceDirectory/"
	output_directory = "Examples/SampleFiles/OutputDirectory/"

	workbook = Workbook(source_directory + "Book2.xlsx")

	# Convert the first table/list object (from the first worksheet) to normal range
	workbook.getWorksheets().get(0).getListObjects().get(0).convertToRange()

	# Save the excel file.
	workbook.save(output_directory + "ConvertTableToRange_out.xlsx")

使用选项将 Excel 表转换为范围

在将表转换为范围时，您可以提供其他选项TableToRange选项班级。你可以传递一个实例TableToRange选项类到[ListObject.convertToRange](https://reference.aspose.com/cells/python/asposecells.api/listobject#convertToRange(com.aspose.cells.TableToRangeOptions)方法来指定附加选项。下面的代码片段演示了使用TableToRange选项类来设置表的最后一行索引。表格格式将保留到指定的行索引，其余格式将被删除。

	source_directory = "Examples/SampleFiles/SourceDirectory/"
	output_directory = "Examples/SampleFiles/OutputDirectory/"

	workbook = Workbook(source_directory + "Book2.xlsx")

	# Convert the first table/list object (from the first worksheet) to normal range
	tableToRangeOptions = TableToRangeOptions()
	tableToRangeOptions.setLastRow(5)

	# Convert the first table/list object (from the first worksheet) to normal range
	workbook.getWorksheets().get(0).getListObjects().get(0).convertToRange(tableToRangeOptions)

	# Save the excel file.
	workbook.save(output_directory + "ConvertTableToRangeWithOptions_out.xlsx")