Get Cells Index
Contents
[
Hide
]
The default view of Excel is A1 style reference，each column is defined as A, B, C…. , and the cells are named as A1, B2, C3… and so on.
You may want to know which row and column is this cell in.
Possible Usage Scenarios
When you only need to manipulate a specific data on the worksheet by row and column index, you need to know the column and column indexes of that specific cell. Aspose.Cells for Python via .NET offers this feature to get row and column index by the name of the row, column and cell. Aspose.Cells for Python via .NET provides the following properties and methods to help you achieve your goals.
- CellsHelper.cell_name_to_index
- CellsHelper.column_index_to_name
- CellsHelper.column_name_to_index
- CellsHelper.row_index_to_name
- CellsHelper.row_name_to_index
Note: The indexing is zero-based in Aspose.Cells for Python via .NET, but the id of Row is one-based in MS Excel.
Get Cells Indexes using Aspose.Cells for Python Excel Library
This example shows how to:
- Create a workbook and add some data.
- Find the specific cell in the first worksheet.
- Get Row index and Column index by the name of the cell.
- Get Column index by the name of the column.
- Get Row index by the name of the row.
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, CellsHelper | |
| # 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) | |
| curr = cells.find("Blackberry", None) | |
| # get row and column index of current cell | |
| currRow = [] | |
| currCol = [] | |
| CellsHelper.cell_name_to_index(curr.name, currRow, currCol) | |
| print("Row Index: " + str(currRow[0]) + " Column Index: " + str(currCol[0])) | |
| # get column name by column index | |
| columnName = CellsHelper.column_index_to_name(currCol[0]) | |
| # get row name by row index | |
| rowName = CellsHelper.row_index_to_name(currRow[0]) | |
| print("Column Name: " + columnName + " Row Name: " + rowName); | |
| # get column index by column name | |
| columnIndex = CellsHelper.column_name_to_index(columnName); | |
| # get row index by row name | |
| rowIndex = CellsHelper.row_name_to_index(rowName) | |
| print("Column Index: " + str(columnIndex) + " Row Index: " + str(rowIndex)) |