Retrieve Maximum Row Number in an Excel Worksheet – Aspose.Cells Cloud API
Contents
[
Hide
]
This REST API returns the maximum row number in an Excel worksheet when the cellOrMethodName parameter is set to maxrow.
- cURL Example
- Use Aspose.Cells Cloud SDKs
Using an SDK is the most efficient way to accelerate development. An SDK handles low‑level details, allowing you to focus on your project logic. Please check the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.
The following code examples demonstrate how to call Aspose.Cells web services using various SDKs:
API Reference
| Item | Details |
|---|---|
| Method | GET |
| Endpoint | /cells/{fileName}/worksheets/{sheetName}/cells/maxrow |
| Path Parameters | fileName – name of the Excel file (required) sheetName – name of the worksheet (required) |
| Query Parameters | folder – folder path in storage (optional) storageName – storage name (optional) |
| Success Response | 200 OK json { "MaxRow": integer } |
| Error Responses | 400 Bad Request – invalid parameters 401 Unauthorized – authentication failure 404 Not Found – file or worksheet not found |
Prerequisites
- A valid Aspose Cloud authentication token.
- The target workbook must be uploaded to Aspose Cloud storage or accessible via a public URL.
Notes
- The operation is available in API version v3.0 and later.
- The returned
MaxRowvalue corresponds to the highest used row index (1‑based). For a blank worksheet, the value is typically1.
The following SDK examples illustrate how to invoke the operation in different programming languages.