Get MinDataRow from Excel Worksheet
The Get MinDataRow endpoint of Aspose.Cells Cloud API v3.0 returns the index of the first row that contains data in a specified worksheet. The operation requires a valid access token (Bearer authentication) and the query parameter cellOrMethodName set to mindatarow.
cURL Example
The request uses the HTTP GET method. Replace the placeholders {fileName} and {sheetName} with the actual workbook and worksheet names.
curl -X GET "https://api.aspose.cloud/v3.0/cells/{fileName}/worksheets/{sheetName}/cells/mindatarow?cellOrMethodName=mindatarow" \
-H "Authorization: Bearer <access_token>" \
-H "Content-Type: application/json" \
-H "Accept: application/json"
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
cellOrMethodName |
string | Yes | Must be set to mindatarow to invoke this operation. |
folder |
string | No | Path to the folder containing the workbook. |
storage |
string | No | Name of the Aspose Cloud storage to use. |
Response
A successful call returns HTTP 200 with a JSON payload that contains the minimum data‑row index (0‑based).
{
"MinDataRow": 5
}
Error Handling
| HTTP Status | Code | Message | When it occurs |
|---|---|---|---|
| 400 | BadRequest | Invalid query parameter. | cellOrMethodName missing or set to an unsupported value. |
| 401 | Unauthorized | Authentication failed. | Missing or invalid Bearer token. |
| 404 | FileNotFound | Worksheet not found. | The specified {fileName} or {sheetName} does not exist. |
| 500 | InternalError | Unexpected server error. | Server‑side problem while processing the request. |
See Also
-
Cloud SDK Family
Using an SDK is the fastest way to develop. An SDK handles low‑level details so you can focus on your project logic. Please check out 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: