访问工作表的 Cells

访问 Cells

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()))