Group columns on an Excel worksheet
Contents
[
Hide
]
This REST API lets you group worksheet columns.
REST API
POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/columns/group
Request Parameters
| Parameter Name | Type | Location | Description |
|---|---|---|---|
| name | string | path | Name of the workbook file. |
| sheetName | string | path | Name of the worksheet containing the columns. |
| firstIndex | integer | query | Zero‑based index of the first column to group. |
| lastIndex | integer | query | Zero‑based index of the last column to group. |
| hide | boolean | query | If true, the grouped columns are hidden; otherwise they remain visible. |
| folder | string | query | Path to the folder that contains the workbook. |
| storageName | string | query | Name of the storage service where the file is located. |
The OpenAPI Specification defines a publicly accessible programming interface and lets you perform REST interactions directly from a web browser.
cURL Example
Success Response
| Field | Type | Description |
|---|---|---|
| Code | integer | HTTP status code (200 for success). |
| Status | string | Textual status of the operation (e.g., OK). |
Error Response
When the request fails, the API returns additional fields describing the error.
| Field | Type | Description |
|---|---|---|
| Code | integer | HTTP status code (e.g., 400, 401, 404, 500). |
| Status | string | Textual status (e.g., Error). |
| ErrorMessage | string | Human‑readable description of the problem. |
| ErrorCode | string | Specific error identifier for programmatic handling. |
Cloud SDK Family
Using an SDK is the fastest way to develop with Aspose.Cells Cloud. An SDK handles low‑level details so you can focus on your business logic. For a complete list of supported SDKs, see the GitHub repository.
The following code examples demonstrate how to call Aspose.Cells web services using various SDKs: