Format Numbers and Date Time

This guide will demonstrate how to format numbers and date time in spreadsheet using UniOffice.

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/number-date-time-formats folder in the unioffice-examples directory.

cd unioffice-examples/spreadsheet/number-date-time-formats/

How it works #

The import section in lines 13-20 imports the necessary libraries from UniOffice and the Go standard libraries.
The init function in lines 13-20 is used to set the metered license key.

The main function is defined in lines 22-72. First a new workbook is created 23-25. In lines 27-31, a cell is set with a number without formatting. Lines 35-36 creates a cell with numeric value and a formatting style is set using:

cell = row.AddCell()
cell.SetNumberWithStyle(0.95, spreadsheet.StandardFormatPercent)

Here the StandardFormatPercent from spreadsheet is used. In line 41 a new CellStyle is created. The date format of the cell style is then set in line 43 using dateStyle.SetNumberFormatStandard(spreadsheet.StandardFormatDate). Then lines 45 and 46 a new date cell with the defined cell style is created using:

cell.SetDate(time.Now())
cell.SetStyle(dateStyle)

Lines 51-58 demonstrate the process of using a style index for faster implementation. This is done using the following code snippet.

cs := ss.StyleSheet.AddCellStyle()
cs.SetNumberFormatStandard(spreadsheet.StandardFormatTime)
idx := cs.Index()
for i := 0; i < 5; i++ {
  cell = row.AddCell()
  cell.SetDate(time.Now())
  cell.SetStyleIndex(idx)
}

First a new cell style with StandardFormatTime as its date formatting style is created. Then the index of this style is obtained by calling the Index method of the CellStyle object. Then in the for loop the style is set using cell.SetStyleIndex(idx).

Lines 61-65, shows how to create a custom number formatting style.

Finally, the workbook is validated and saved to file in lines 67-71.

Run the code #

Run the code using the following command.

go run main.go

Sample Output #