Get MinRow from Excel Worksheet – Aspose.Cells Cloud API Reference

This REST API returns the minimum row index in an Excel worksheet when the cellOrMethodName parameter is set to minrow. The endpoint can be used to determine the first non‑empty row (zero‑based) in a given worksheet.

cURL Example:

Request

curl -X GET "https://api.aspose.com/v3.0/cells/myWorkbook.xlsx/worksheets/Sheet1/cells/minrow" \
     -H "Authorization: Bearer <access_token>" \
     -H "Content-Type: application/json" \
     -H "Accept: application/json"

{
  "MinRow": 0
}

Request

GET https://api.aspose.com/v3.0/cells/{fileName}/worksheets/{sheetName}/cells/minrow

Property	Type	Required	Description
`fileName`	string	Yes	Name of the workbook (e.g., `myWorkbook.xlsx`).
`sheetName`	string	Yes	Target worksheet (e.g., `Sheet1`).
`cellOrMethodName`	string	Yes	Fixed value `minrow`.
`folder`	string	No	Cloud storage folder path.
`storageName`	string	No	Storage name if a non‑default storage is used.

Response

The service returns a JSON object that contains the MinRow property, indicating the index of the first non‑empty row (zero‑based).

HTTP Status	Meaning
200	Success – JSON payload with `MinRow`.
401	Unauthorized – invalid or missing token.
404	Workbook or worksheet not found.
500	Internal server error.

The MinRow value is useful when you need to quickly locate the starting point of data in a sheet.

Use Aspose.Cells Cloud SDKs

Using an SDK is the fastest way to develop. An SDK handles low‑level details so you can focus on your project. 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:

Aspose.Cells Cloud API – Get MaxDataColumn of an Excel Worksheet (v3.0) Get MinDataRow from Excel Worksheet