Get MinDataColumn – Aspose.Cells Cloud API Reference (v3.0)
Contents
[
Hide
]
Overview
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.
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"
Path Parameters
| Parameter | Type | Description |
|---|---|---|
myWorkbook.xlsx |
string | Name of the workbook stored in the cloud. |
Sheet1 |
string | Worksheet name (case‑sensitive). |
mindatacolumn |
literal | Fixed operation name that triggers the endpoint. |
There are no additional query parameters for this operation.
Response
Successful Response (200 OK)
{
"MinDataColumn": 2
}
| Property | Type | Description |
|---|---|---|
MinDataColumn |
integer | Zero‑based index of the first column that contains data. |
Error Responses
| HTTP Code | Error Code | Description |
|---|---|---|
| 401 | AuthenticationFailed |
Missing or invalid authentication credentials. |
| 404 | WorksheetNotFound |
The specified worksheet does not exist in the workbook. |
| 400 | InvalidRequest |
The request is malformed or contains invalid parameters. |
| 500 | ServerError |
An unexpected error occurred on the server side. |
Request / Response Samples
- cURL Example
Cloud SDK Family
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: