管理工作表

使用Aspose.Cells for Python via Java管理工作表非常容易。在本文中,我们将演示如何使用Aspose.Cells API添加、访问和删除工作表。

向新的Excel文件添加工作表

要创建新的工作簿,请创建Workbook类的对象。Workbook类表示一个Excel文件。然后,通过WorksheetCollection的add方法向Excel文件添加新工作表。最后,调用Workbook类的save方法保存新创建的Excel文件。

以下代码段演示了如何创建一个新的Excel文件并向其中添加一个工作表。

output_directory = "Examples/SampleFiles/OutputDirectory/"
# Instantiating a Workbook object
workbook = Workbook()
# Adding a new worksheet to the Workbook object
worksheets = workbook.getWorksheets()
sheetIndex = worksheets.add()
worksheet = worksheets.get(sheetIndex)
# Setting the name of the newly added worksheet
worksheet.setName("My Worksheet")
# Save the excel file.
workbook.save(output_directory + "AddingWorksheetsToNewExcelFile_out.xlsx")

向设计电子表格添加工作表

向设计师电子表格添加工作表与向新的Excel文件添加工作表完全相同。唯一的区别是,不是创建新的Excel文件,而是通过Workbook类打开现有文件。

以下代码段演示了向设计师电子表格添加工作表。

source_directory = "Examples/SampleFiles/SourceDirectory/"
output_directory = "Examples/SampleFiles/OutputDirectory/"
# Open an existing workbook
workbook = Workbook(source_directory + "book.xls")
# Adding a new worksheet to the Workbook object
worksheets = workbook.getWorksheets()
sheetIndex = worksheets.add()
worksheet = worksheets.get(sheetIndex)
# Setting the name of the newly added worksheet
worksheet.setName("My Worksheet")
# Save the excel file.
workbook.save(output_directory + "AddingWorksheetsToDesignerSpreadsheet_out.xlsx")

使用工作表名称访问工作表

加载工作簿后,开发人员可以通过其索引或名称访问任何工作表。以下代码片段演示了如何使用工作表名称访问工作表。

source_directory = "Examples/SampleFiles/SourceDirectory/"
workbook = Workbook(source_directory + "Book1.xlsx")
# Accessing a worksheet using its sheet name
worksheet = workbook.getWorksheets().get("Sheet1")
cell = worksheet.getCells().get(3, 3)
print(cell.getValue())

移除工作表

有时需要从工作簿中移除一些工作表。为此,API提供了WorksheetCollection.removeAt方法。您可以传递工作表索引或工作表名称来移除工作表。以下示例演示了如何使用工作表索引和工作表名称来移除工作表。

使用工作表索引移除工作表

source_directory = "Examples/SampleFiles/SourceDirectory/"
output_directory = "Examples/SampleFiles/OutputDirectory/"
workbook = Workbook(source_directory + "Book1.xlsx")
# Removing a worksheet using its sheet name
workbook.getWorksheets().removeAt(0)
# Save the excel file.
workbook.save(output_directory + "RemovingWorksheetsUsingSheetIndex_out.xlsx")

使用工作表名称移除工作表

source_directory = "Examples/SampleFiles/SourceDirectory/"
output_directory = "Examples/SampleFiles/OutputDirectory/"
workbook = Workbook(source_directory + "Book1.xlsx")
# Removing a worksheet using its sheet name
workbook.getWorksheets().removeAt("Sheet1")
# Save the excel file.
workbook.save(output_directory + "RemovingWorksheetsUsingSheetName_out.xlsx")