Get Cells Range
Contents
[
Hide
]
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:
- Create a workbook.
- Add data to cells in the first worksheet.
- Get Cells Range.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |