Find Answers by API

Adding a Column in Excel using Python REST API

This tutorial guides you in adding a column in Excel using Python REST API. You will learn how to add a whole column in Excel using Python-based API with Python-based Cloud SDK. It assists in selecting the target sheet, start column, and total columns that you want to insert.

Prerequisite

Steps for Making Columns in Excel using Python Low Code API

  1. Provide your Aspose Cloud App Key and App Secret to authenticate your access to the Aspose.Cells API
  2. Use these credentials to initialize the CellsApi client that will manage all interactions with the cloud service
  3. Select the Excel file on your local machine that you want to modify
  4. Upload the selected Excel file to Aspose Cloud so it can be processed remotely
  5. Set up the details for inserting new columns, including worksheet name, column index, number of columns, and reference updates
  6. Send the configured column insertion request PutInsertWorksheetColumns to the Aspose.Cells API to apply changes to the worksheet
  7. After processing, download the modified Excel file from the cloud storage
  8. Save the downloaded file locally with a new name to preserve the original version

These steps summarize how to add a new column in Excel using Python-based API. To modify an Excel file using Aspose.Cells Cloud, authenticate with your API credentials, upload the file, configure the column insertion, and send the request to update the worksheet. After processing, download the modified file and save it locally while handling any potential errors.

Code for Adding Multiple Columns in Excel using Python RESTful Service

The above code demonstrates how to create a column in Excel using Python Low Code API. You can add multiple columns by setting the desired number in the respective parameter “columns” in the PutInsertWorksheetColumnsRequest(). The “updateReference” property is set to “true” for updating references in the workbook dependent on these columns.

This article has taught us the process of adding columns. To delete a chart, refer to the article Delete chart in Excel using Python REST API.

 

 English