Get Cells Index

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 offers this feature to get row and column index by the name of the row, column and cell. Aspose.Cells provides the following properties and methods to help you achieve your goals.

Note: The indexing is zero-based in Aspose.Cells for .Net, but the id of Row is one-based in MS Excel.

Get Cells Indexes using Aspose.Cells

This example shows how to:

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