Get MinDataColumn – Aspose.Cells Cloud API Reference (v3.0)
Contents
[
Hide
]
The mindatacolumn endpoint returns the zero‑based index of the leftmost column that contains any cell data in a specified worksheet.
In other words, it tells you which column is the first one that actually holds data.
Definition –
mindatacolumn: the index (starting at 0) of the first column that contains data in the worksheet.
Prerequisites
- A valid OAuth2 access token is required.
- The Excel file must be uploaded to Aspose Cloud storage.
Request Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
fileName |
string | Yes | Name of the Excel file stored in cloud storage. |
sheetName |
string | Yes | Name of the worksheet from which to retrieve the column index. |
Authorization (header) |
string | Yes | Bearer token for OAuth2 authentication. |
- cURL Example
curl -X GET "https://api.aspose.com/v3.0/cells/myWorkbook.xlsx/worksheets/Sheet1/cells/mindatacolumn" \
-H "Authorization: Bearer {access_token}" \
-H "Content-Type: application/json" \
-H "Accept: application/json"
HTTP Status Codes
| Code | Meaning | Description |
|---|---|---|
| 200 | OK | Filter applied successfully; response contains operation details. |
| 400 | Bad Request | Missing or invalid parameters (e.g., unsupported file type). |
| 401 | Unauthorized | Invalid or missing JWT token. |
| 413 | Payload Too Large | Uploaded file exceeds size limit. |
| 500 | Internal Server Error | Unexpected server error. |
- Use Aspose.Cells Cloud SDKs
Using an SDK is the best 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: