Cell Comments

This guide explains how to create a spreadsheet cell with comments.

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 https://github.com/unidoc/unioffice-examples

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

cd unioffice-examples/spreadsheet/comments/

How it works

The import section in lines 4-10 imports the necessary packages. Then in the init function a metered license API key is set.

The main function is defined in line 21-35. In lines 22-24, a new workbook with a new sheet is created using:

ss := spreadsheet.New()
sheet := ss.AddSheet()

Line 26 set the sheet cell A1 with a text Hello World!. Then lines 27-28 add comments to cell A1 and C10 using:

sheet.Comments().AddCommentWithStyle("A1", "Gopher", "This looks interesting.")
sheet.Comments().AddCommentWithStyle("C10", "Gopher", "This is a different comment.")

Finally, the spreadsheet is validated and saved to file in line 30-34.

Run the code

Run the following command to create the sample spreadsheet file.

go run main.go

Sample output

Spreadsheet file.

sample cell-comments

Got any Questions?

We're here to help you.