Get Cells Range

Possible Usage Scenarios

When you only need to manipulate some data on the worksheet, you need to know the data range of the entire worksheet. Aspose.Cells for Python via .NET offers this feature. Aspose.Cells for Python via .NET provides the following properties and methods to help you achieve your goals.

Get Cells Range using Aspose.Cells

This example shows how to:

  1. Create a workbook.
  2. Add data to cells in the first worksheet.
  3. Get Cells 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)