Insert Images

This guide will demonstrate how to insert an image to a spreadsheet file.

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/image folder in the unioffice-examples directory.

cd unioffice-examples/spreadsheet/image/

How it works

The import section in lines 4-13 imports the necessary libraries from UniOffice and Go. Then, the init function in lines 15-22 sets the metered license key using license.SetMeteredKey(os.Getenv(`UNIDOC_LICENSE_API_KEY`)).

The main function starts in line 24. In lines 25-28 of this function, a new workbook with new sheet is created using:

ss := spreadsheet.New()
defer ss.Close()
// add a single sheet
sheet := ss.AddSheet()

Then the image is loaded from file in lines 30. In line 35, an image reference is created using AddImage method of the spreadsheet.Sheet object. Then a new spreadsheet.Drawing is added to the Workbook in lines 40-41. In the next section, i.e. 42-55 adds the image to the drawing multiple times circularly. This is done using the following snippet code:

for i := float64(0); i < 360; i += 30 {
  anc := dwng.AddImage(iref, spreadsheet.AnchorTypeAbsolute)

  ang := i * math.Pi / 180
  x := 2 + 2*math.Cos(ang)
  y := 2 + +2*math.Sin(ang)
  anc.SetColOffset(measurement.Distance(x) * measurement.Inch)
  anc.SetRowOffset(measurement.Distance(y) * measurement.Inch)

  // set the image to 1x1 inches
  var w measurement.Distance = 1 * measurement.Inch

The for loop basically iterates by 30 degree increments and draws the image. First the x and y positions are computed using the current angle. i.e. x := 2 + 2*math.Cos(ang) and y := 2 + +2*math.Sin(ang). This formula for x and y gives us a list of points arranged in a circle. The columns offset and row offset of the spreadsheet.Anchor are then applied in lines 48-49 using the coordinates computed above. Lines 52-54 set the width and height of the images. The document is then validated in line 57 and saved to file in line 61.

Run the code

Use the following command to run the code.

go run main.go

Sample Output

sample spreadsheet with images

Got any Questions?

We're here to help you.