Remove Column

This guide will demonstrate the process of removing a specific column from a spreadsheet using UniOffice.

Sample input


Before you begin

You should get your API key from your UniCloud account.

If this is your first time using UniOffice SDK, follow this guide to set up a local development environment.

Clone the project repository

In your terminal, clone the examples repository. It contains the Go code we will be using for this guide.

git clone

To get the example navigate to the path spreadsheet/remove-column folder in the unioffice-examples directory.

cd unioffice-examples/spreadsheet/remove-column/

How it works

The import section imports the necessary libraries. The init function in lines 14-21 initializes the package by setting the metered license key using license.SetMeteredKey(os.Getenv(`UNIDOC_LICENSE_API_KEY`)). This authorizes the library request.

The main function defined in lines 23-51 contains the code that is used to remove a column. First, the workbook is loaded from a file in line 24. The target sheet is obtained by name from the workbook using ss.GetSheet("Cells"). Here cells is the name of the sheet we are interested in. Then in line 35 the column C is removed from the sheet using sheet0.RemoveColumn("C"). Lines 40-45, removes column C from sheet MergedCells in the same manner. Finally, in line 50, the new workbook is saved to file.

Run the code

Use the following command to run the code.

go run main.go

Sample Output


Got any Questions?

We're here to help you.