Get Cells Index

The default view of Excel is the A1‑style reference; each column is labeled A, B, C…, and cells are named A1, B2, C3…, and so on.
You may want to know which row and column this cell is in.

Possible Usage Scenarios

When you only need to manipulate specific data on the worksheet by row and column index, you need to know the row and column indexes of that specific cell.
Aspose.Cells for Python via .NET offers this feature to get row and column indexes by the name of the row, column, or 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 row index is one‑based in Microsoft Excel.

Get Cell Indexes using Aspose.Cells for Python via .NET

This example shows how to:

1. Create a workbook and add some data.
2. Find a specific cell in the first worksheet.
3. Get the row index and column index by the name of the cell.
4. Get the column index by the name of the column.
5. Get the row index by the name of the row.