Add Empty Column to Excel Worksheet Using Aspose.Cells Cloud API

This REST API inserts one or more columns into a worksheet.

Prerequisites
Before calling this endpoint, ensure you have completed the following steps:

  • Obtain a valid OAuth 2.0 access token and include it in the Authorization header.
  • Store the target workbook in the selected storage (default = “Default”) or specify the appropriate folder and storageName parameters.
  • Verify that the worksheet name provided in sheetName exists in the workbook.

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.

Response codes

Code Description
200 Column(s) inserted successfully.
400 Bad request – missing or invalid parameters.
401 Unauthorized – invalid or missing token.
404 Workbook or worksheet not found.
500 Internal server error.

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:

Get Column Details – Aspose.Cells Cloud API Reference (v4.0) Copy columns in an Excel worksheet