Get Max Column Index in Row and Max Row Index in Column

Possible Usage Scenarios

When you only need to manipulate some data on the rows or columns, you need to know the data range of rows and columns. Aspose.Cells for Python via .NET offers this feature. To obtain the maximum column index on a row, you can obtain the Row.last_cell and Row.last_data_cell properties, and then use the Cell.column property to obtain the maximum column index and maximum data column index. However, to obtain the maximum row index and maximum data row index on a column, you need to create a range on the column, traverse the range to find the last cell, and finally obtain the Cell.row attribute on that cell.

Aspose.Cells for Python via .NET provides the following properties and methods to help you achieve your goals.

• Row.last_cell
• Row.last_data_cell
• Cell.column
• Cell.row

Get Max Column Index in Row and Max Row Index in Column using Aspose.Cells for Python Excel Library

This example shows how to:

1. Load the sample file.
2. Get the row for which you need to obtain the maximum column index and maximum data column index.
3. Retrieve the Cell.column attribute on the cell.
4. Create a range based on the column.
5. Obtain an iterator and traverse the range.
6. Retrieve the Cell.row attribute on the cell.