Obtenir la plage de cellules
Scénarios d’utilisation possibles
Lorsque vous avez seulement besoin de manipuler certaines données sur la feuille de calcul, vous devez connaître la plage de données de la feuille de calcul entière. Aspose.Cells for Python via .NET offre cette fonctionnalité. Aspose.Cells for Python via .NET fournit les propriétés et méthodes suivantes pour vous aider à atteindre vos objectifs.
Obtenir la plage de cellules en utilisant Aspose.Cells
Cet exemple montre comment :
- Créer un classeur.
- Ajouter des données aux cellules dans la première feuille de calcul.
- Obtenir les cellules 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) |