访问工作表的单元格

访问单元格

Aspose.Cells for Python via Java 允许您通过使用单元格名称或行列索引来访问工作表中的单元格。本文展示了访问工作表中单元格的这两种方法。

使用单元格名称访问单元格

以下代码片段演示了使用单元格名称访问单元格。示例代码访问单元格 “C5” 并打印其值。

source_directory = "Examples/SampleFiles/SourceDirectory/"
# Instantiating a Workbook object
workbook = Workbook(source_directory + "Book1.xlsx")
# Accessing the worksheet in the Excel file
worksheet = workbook.getWorksheets().get(0)
cells = worksheet.getCells()
# Accessing a cell using its name
cell = cells.get("C5")
# Print Message
print("Cell Value: " + str(cell.getValue()))

使用行和列索引访问单元格

以下代码片段演示了使用行和列索引访问单元格。示例代码访问并打印由行索引 4 和列索引 2 标识的单元格 “C5” 的值。

source_directory = "Examples/SampleFiles/SourceDirectory/"
# Instantiating a Workbook object
workbook = Workbook(source_directory + "Book1.xlsx")
# Accessing the worksheet in the Excel file
worksheet = workbook.getWorksheets().get(0)
cells = worksheet.getCells()
# Accessing a cell using the row and column index
cell = cells.get(4, 2)
# Print Message
print("Cell Value: " + str(cell.getValue()))