Add an Empty Column to an Excel Worksheet – Aspose.Cells Cloud API
This REST API inserts one or more columns into a worksheet.
Before invoking the endpoint, obtain an OAuth 2.0 access token and include it in the Authorization header. Ensure the workbook is stored in the selected storage (default = “Default”).
REST API
PUT https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex}?totalColumns=1
Request parameters
| Parameter Name | Type | Location | Description |
|---|---|---|---|
| name | string | path | The workbook file name. |
| sheetName | string | path | The worksheet name. |
| columnIndex | integer | path | Zero‑based index of the column where insertion begins. |
| totalColumns | integer | query | Number of columns to insert. |
| updateReference | boolean | query | When true, cell references are updated to reflect the insertion. |
| folder | string | query | Path to the folder containing the workbook. |
| storageName | string | query | Name of the storage service. |
The OpenAPI Specification defines a publicly accessible programming interface and lets you perform REST interactions directly from a web browser.
You can use the cURL command‑line tool to call Aspose.Cells web services. The following example shows a complete request, including authentication and the correct path parameter.
Cloud SDK Family
Using an SDK is the fastest way to develop. An SDK handles low‑level details so you can focus on your project logic. See 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: