Ungroup Columns in Excel

Aspose.Cells Cloud provides a POST operation that removes column grouping from a specified worksheet. This page details the request format, required parameters, authentication method, example calls, and SDK usage.

Prerequisites

Requirement Why It’s Needed
Aspose Cloud account Access to the Aspose.Cells Cloud services.
JWT access token All API calls must be authorized with a bearer token. See the JWT authentication guide.
Workbook stored in Aspose Cloud Storage The API works on files located in the cloud storage (or a connected external storage).
Worksheet name The target worksheet must exist in the workbook.

Authentication

All requests require an Authorization header containing a valid JWT token:

Authorization: Bearer <access_token>

The token is obtained via the Aspose Cloud OAuth flow. Tokens are valid for a limited period; refresh as needed.

Endpoint

POST https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/columns/ungroup

Parameters

Path Parameters

Name Type Required Description
name string Yes The workbook file name.
sheetName string Yes The worksheet name.

Query Parameters

Name Type Required Description
firstIndex integer Yes Zero‑based index of the first column to ungroup.
lastIndex integer Yes Zero‑based index of the last column to ungroup.
folder string No Folder path that contains the workbook.
storageName string No Name of the storage service where the file resides.

Request Example (cURL)

curl -X POST "https://api.aspose.cloud/v3.0/cells/test.xlsx/worksheets/Sheet1/cells/columns/ungroup?firstIndex=1&lastIndex=5" \
     -H "Authorization: Bearer <access_token>" \
     -H "Accept: application/json"

Replace <access_token> with a valid JWT token.

Successful Response

{
  "Code": 200,
  "Status": "OK",
  "Columns": {
    "FirstIndex": 1,
    "LastIndex": 5
  }
}

The response object (CellsCloudResponse) contains the range of columns that were successfully ungrouped.

Error Response

When the request fails, the service returns a JSON payload with the following fields:

Field Meaning
Code HTTP‑style error code (e.g., 400, 401).
Status Short description of the error.
ErrorMessage Detailed error description.

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.

SDK Code Samples

Below are ready‑to‑run snippets for the most popular SDKs. Replace placeholder values (<YourAccessToken>, <YourFileName>, etc.) with your own data.

**C# (.NET)** 
using Aspose.Cells.Cloud.SDK.Api;
using Aspose.Cells.Cloud.SDK.Model;
using System;

class Program
{
    static void Main()
    {
        var config = new Configuration
        {
            AccessToken = "<YourAccessToken>",
            BaseUrl = "https://api.aspose.cloud"
        };
        var cellsApi = new CellsApi(config);

        var response = cellsApi.PostUngroupWorksheetColumns(
            name: "test.xlsx",
            sheetName: "Sheet1",
            firstIndex: 1,
            lastIndex: 5,
            folder: null,
            storageName: null);

        Console.WriteLine($"Ungrouped columns: {response.Columns.FirstIndex} – {response.Columns.LastIndex}");
    }
}
**Java** 
import com.aspose.cells.cloud.api.CellsApi;
import com.aspose.cells.cloud.model.CellsCloudResponse;
import com.aspose.cells.cloud.Configuration;

public class UngroupColumns {
    public static void main(String[] args) throws Exception {
        Configuration config = new Configuration();
        config.setAccessToken("<YourAccessToken>");
        config.setBaseUrl("https://api.aspose.cloud");
        CellsApi api = new CellsApi(config);

        CellsCloudResponse resp = api.postUngroupWorksheetColumns(
            "test.xlsx",
            "Sheet1",
            1,
            5,
            null,
            null);

        System.out.println("Ungrouped columns: " + resp.getColumns().getFirstIndex()
                           + " – " + resp.getColumns().getLastIndex());
    }
}
**Python** 
from asposecellscloud import CellsApi, Configuration

config = Configuration()
config.access_token = "<YourAccessToken>"
config.base_url = "https://api.aspose.cloud"

api = CellsApi(config)

response = api.post_ungroup_worksheet_columns(
    name="test.xlsx",
    sheet_name="Sheet1",
    first_index=1,
    last_index=5,
    folder=None,
    storage_name=None)

print(f"Ungrouped columns: {response.columns.first_index} – {response.columns.last_index}")
**Node.js** 
const { CellsApi, Configuration } = require('asposecellscloud');

const config = new Configuration({
    accessToken: "<YourAccessToken>",
    baseUrl: "https://api.aspose.cloud"
});

const api = new CellsApi(config);

api.postUngroupWorksheetColumns("test.xlsx", "Sheet1", 1, 5, null, null)
   .then(resp => {
       console.log(`Ungrouped columns: ${resp.columns.firstIndex} – ${resp.columns.lastIndex}`);
   })
   .catch(err => console.error(err));
**Go** 
package main

import (
    "fmt"
    "github.com/asposecellscloud/aspose-cells-cloud-go/v3/sdk"
)

func main() {
    config := sdk.NewConfiguration()
    config.AccessToken = "<YourAccessToken>"
    config.BasePath = "https://api.aspose.cloud"

    api := sdk.NewCellsApi(config)

    resp, _, err := api.PostUngroupWorksheetColumns(
        "test.xlsx",
        "Sheet1",
        1,
        5,
        nil,
        nil,
    )
    if err != nil {
        panic(err)
    }
    fmt.Printf("Ungrouped columns: %d – %d\n", resp.Columns.FirstIndex, resp.Columns.LastIndex)
}

Note: SDKs for PHP, Ruby, Perl, and other languages follow the same parameter order. Refer to the GitHub repository for complete examples.

References

Revision History

Date Author Change
2026‑07‑30 AI Optimizer Fixed UTF‑8 encoding, added Prerequisites, cleaned meta keywords, improved heading hierarchy, and inserted SDK snippets.
2026‑07‑29 Original Initial documentation draft.