管理工作表
使用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") |