获取单元格范围

可能的使用场景

当您仅需要处理工作表上的一些数据时，您需要知道整个工作表的数据范围。 Aspose.Cells for Python via .NET提供了此功能。Aspose.Cells for Python via .NET提供以下属性和方法来帮助您实现目标。

• Cells.max_display_range
• Cells.max_row
• Cells.max_data_row
• Cells.max_column
• Cells.max_data_column

使用Aspose.Cells获取单元格范围

此示例演示如何：

1. 创建一个工作簿。
2. 在第一个工作表中的单元格中添加数据。
3. 获取单元格 Range。

from aspose.cells import Workbook
from aspose.pydrawing import Color

# Instantiating an Workbook object
workbook = Workbook()
# Obtaining the reference of the newly added worksheet
ws = workbook.worksheets[0]
cells = ws.cells
# Setting the value to the cells
cell = cells.get("A1")
cell.put_value("Fruit")
cell = cells.get("B1")
cell.put_value("Count")
cell = cells.get("C1")
cell.put_value("Price")
cell = cells.get("A2")
cell.put_value("Apple")
cell = cells.get("A3")
cell.put_value("Mango")
cell = cells.get("A4")
cell.put_value("Blackberry")
cell = cells.get("A5")
cell.put_value("Cherry")
cell = cells.get("B2")
cell.put_value(5)
cell = cells.get("B3")
cell.put_value(3)
cell = cells.get("B4")
cell.put_value(6)
cell = cells.get("B5")
cell.put_value(4)
cell = cells.get("C2")
cell.put_value(5)
cell = cells.get("C3")
cell.put_value(20)
cell = cells.get("C4")
cell.put_value(30)
cell = cells.get("C5")
cell.put_value(60)
cell = cells.get("E10")
temp = workbook.create_style()
temp.font.color = Color.red
cell.set_style(temp)
#  Get max display range of worksheet
range = cells.max_display_range
# get maximum row index of cell which contains data or style.
print(cells.max_row)
# get maximum row index of cell which contains data.
print(cells.max_data_row)
# get maximum column index of cell which contains data or style.
print(cells.max_column)
# get maximum column index of cell which contains data.
print(cells.max_data_column)