How to write data to an Excel file using Golang

A detailed guide on how to write data to an Excel file using Golang with the excelize library.

In this article, you will learn how to write data from Golang to an Excel file using the excelize library. This is a powerful and flexible library that allows you to manipulate Excel files easily.

package main

import (
    "fmt"
    "github.com/xuri/excelize/v2"
)

func main() {
    // Create a new Excel file
    f := excelize.NewFile()
    
    // Write data to cells in the sheet
    f.SetCellValue("Sheet1", "A1", "Name")
    f.SetCellValue("Sheet1", "B1", "Age")
    f.SetCellValue("Sheet1", "C1", "City")

    f.SetCellValue("Sheet1", "A2", "Nguyen Van A")
    f.SetCellValue("Sheet1", "B2", 23)
    f.SetCellValue("Sheet1", "C2", "Hanoi")

    f.SetCellValue("Sheet1", "A3", "Tran Thi B")
    f.SetCellValue("Sheet1", "B3", 34)
    f.SetCellValue("Sheet1", "C3", "Da Nang")

    f.SetCellValue("Sheet1", "A4", "Le Van C")
    f.SetCellValue("Sheet1", "B4", 29)
    f.SetCellValue("Sheet1", "C4", "Ho Chi Minh City")

    // Save the Excel file
    if err := f.SaveAs("data.xlsx"); err != nil {
        fmt.Println(err)
    } else {
        fmt.Println("Data written to Excel file successfully!")
    }
}

Detailed explanation

1. import "github.com/xuri/excelize/v2": Import the excelize library to work with Excel files.
2. f := excelize.NewFile(): Create a new Excel file.
3. f.SetCellValue(...): Write data to cells in the Excel file.
4. f.SaveAs("data.xlsx"): Save the Excel file with the name data.xlsx.
5. fmt.Println(...): Display a message indicating successful data writing or an error.

System Requirements

• Golang version 1.16 or higher
• Library: excelize

How to install the libraries needed to run the Golang code above

Run the following command in the terminal:

go get github.com/xuri/excelize/v2

Tips

Make sure you have write permissions in the directory where you want to save the Excel file. Also, if you're new to Golang, start with simple data before working with more complex Excel files.