Group columns

Manage the column groups of your online spreadsheets using the following methods.

Documentation

Available methods for column groups management.

setColumnGroup

Set a group of columns.

Parameter	Description
`column`	index of the first column of the group.
`numOfItems`	number of columns in the group.
`state`	group state (open or closed).

POST /api/:guid/:worksheetIndex/group/columns

resetColumnGroup

Undo a group of columns.

Parameter	Description
`column`	index of the first column of the group.

POST /api/:guid/:worksheetIndex/group/columns

Examples

Set column group

Add a group of columns from the second column to the fourth.

const baseUrl = 'http://localhost:8009/api';
const guid = '79b45919-c751-4e2b-a49a-6c1286e2fc03';
const token = 'eyJhbGciOiJIUzUxMiIsInR5cCJ9.eyJkb21haW4iOiJsb2NhbGhvc3Q6ODAPQSJ9.Xr2Ir2-zEc_tqV5y6i';
const headers = { 'Authorization': `Bearer ${token}` };

// Set column group
await fetch(`${baseUrl}/${guid}/0/group/columns`, {
    method: 'POST',
    headers,
    body: new URLSearchParams({
        'column': '1',
        'numOfItems': '2',
    }),
});