Golang library for reading and writing Microsoft Excel&trade; (XLSX) files.

<img width="650" src="./excelize.svg" alt="Excelize logo">


 <a href="https://github.com/xuri/excelize/actions/workflows/go.yml"><img src="https://github.com/xuri/excelize/actions/workflows/go.yml/badge.svg" alt="Build Status"></a>
 <a href="https://codecov.io/gh/qax-os/excelize"><img src="https://codecov.io/gh/qax-os/excelize/branch/master/graph/badge.svg" alt="Code Coverage"></a>
 <a href="https://goreportcard.com/report/github.com/xuri/excelize/v2"><img src="https://goreportcard.com/badge/github.com/xuri/excelize/v2" alt="Go Report Card"></a>
 <a href="https://pkg.go.dev/github.com/xuri/excelize/v2"><img src="https://img.shields.io/badge/go.dev-reference-007d9c?logo=go&logoColor=white" alt="go.dev"></a>
 <a href="https://opensource.org/licenses/BSD-3-Clause"><img src="https://img.shields.io/badge/license-bsd-orange.svg" alt="Licenses"></a>
 <a href="https://www.paypal.com/paypalme/xuri"><img src="https://img.shields.io/badge/Donate-PayPal-green.svg" alt="Donate"></a>


# Excelize

## Introduction

Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLAM / XLSM / XLSX / XLTM / XLTX files. Supports reading and writing spreadsheet documents generated by Microsoft Excel&trade; 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data. This library needs Go version 1.18 or later. There are some [incompatible changes](https://github.com/golang/go/issues/61881) in the Go 1.21.0, the Excelize library can not working with that version normally, if you are using the Go 1.21.x, please upgrade to the Go 1.21.1 and later version. The full docs can be seen using go's built-in documentation tool, or online at [go.dev](https://pkg.go.dev/github.com/xuri/excelize/v2) and [docs reference](https://xuri.me/excelize/).

## Basic Usage

### Installation

```bash
go get github.com/xuri/excelize
```

- If your packages are managed using [Go Modules](https://go.dev/blog/using-go-modules), please install with following command.

```bash
go get github.com/xuri/excelize/v2
```

### Create spreadsheet

Here is a minimal example usage that will create spreadsheet file.

```go
package main

import (
 "fmt"

 "github.com/xuri/excelize/v2"
)

func main() {
 f := excelize.NewFile()
 defer func() {
 if err := f.Close(); err != nil {
 fmt.Println(err)
 }
 }()
 // Create a new sheet.
 index, err := f.NewSheet("Sheet2")
 if err != nil {
 fmt.Println(err)
 return
 }
 // Set value of a cell.
 f.SetCellValue("Sheet2", "A2", "Hello world.")
 f.SetCellValue("Sheet1", "B2", 100)
 // Set active sheet of the workbook.
 f.SetActiveSheet(index)
 // Save spreadsheet by the given path.
 if err := f.SaveAs("Book1.xlsx"); err != nil {
 fmt.Println(err)
 }
}
```

### Reading spreadsheet

The following constitutes the bare to read a spreadsheet document.

```go
package main

import (
 "fmt"

 "github.com/xuri/excelize/v2"
)

func main() {
 f, err := excelize.OpenFile("Book1.xlsx")
 if err != nil {
 fmt.Println(err)
 return
 }
 defer func() {
 // Close the spreadsheet.
 if err := f.Close(); err != nil {
 fmt.Println(err)
 }
 }()
 // Get value from cell by given worksheet name and cell reference.
 cell, err := f.GetCellValue("Sheet1", "B2")
 if err != nil {
 fmt.Println(err)
 return
 }
 fmt.Println(cell)
 // Get all the rows in the Sheet1.
 rows, err := f.GetRows("Sheet1")
 if err != nil {
 fmt.Println(err)
 return
 }
 for _, row := range rows {
 for _, colCell := range row {
 fmt.Print(colCell, "\t")
 }
 fmt.Println()
 }
}
```

### Add chart to spreadsheet file

With Excelize chart generation and management is as easy as a few lines of code. You can build charts based on data in your worksheet or generate charts without any data in your worksheet at all.

<img width="650" src="./test/images/chart.png" alt="Excelize">

```go
package main

import (
 "fmt"

 "github.com/xuri/excelize/v2"
)

func main() {
 f := excelize.NewFile()
 defer func() {
 if err := f.Close(); err != nil {
 fmt.Println(err)
 }
 }()
 for idx, row := range [][]interface{}{
 {nil, "Apple", "Orange", "Pear"}, {"Small", 2, 3, 3},
 {"Normal", 5, 2, 4}, {"Large", 6, 7, 8},
 } {
 cell, err := excelize.CoordinatesToCellName(1, idx+1)
 if err != nil {
 fmt.Println(err)
 return
 }
 f.SetSheetRow("Sheet1", cell, &row)
 }
 if err := f.AddChart("Sheet1", "E1", &excelize.Chart{
 Type: excelize.Col3DClustered,
 Series: []excelize.ChartSeries{
 {
 Name: "Sheet1!$A$2",
 Categories: "Sheet1!$B$1:$D$1",
 Values: "Sheet1!$B$2:$D$2",
 },
 {
 Name: "Sheet1!$A$3",
 Categories: "Sheet1!$B$1:$D$1",
 Values: "Sheet1!$B$3:$D$3",
 },
 {
 Name: "Sheet1!$A$4",
 Categories: "Sheet1!$B$1:$D$1",
 Values: "Sheet1!$B$4:$D$4",
 }},
 Title: []excelize.RichTextRun{
 {
 Text: "Fruit 3D Clustered Column Chart",
 },
 },
 }); err != nil {
 fmt.Println(err)
 return
 }
 // Save spreadsheet by the given path.
 if err := f.SaveAs("Book1.xlsx"); err != nil {
 fmt.Println(err)
 }
}
```

### Add picture to spreadsheet file

```go
package main

import (
 "fmt"
 _ "image/gif"
 _ "image/jpeg"
 _ "image/png"

 "github.com/xuri/excelize/v2"
)

func main() {
 f, err := excelize.OpenFile("Book1.xlsx")
 if err != nil {
 fmt.Println(err)
 return
 }
 defer func() {
 // Close the spreadsheet.
 if err := f.Close(); err != nil {
 fmt.Println(err)
 }
 }()
 // Insert a picture.
 if err := f.AddPicture("Sheet1", "A2", "image.png", nil); err != nil {
 fmt.Println(err)
 }
 // Insert a picture to worksheet with scaling.
 if err := f.AddPicture("Sheet1", "D2", "image.jpg",
 &excelize.GraphicOptions{ScaleX: 0.5, ScaleY: 0.5}); err != nil {
 fmt.Println(err)
 }
 // Insert a picture offset in the cell with printing support.
 enable, disable := true, false
 if err := f.AddPicture("Sheet1", "H2", "image.gif",
 &excelize.GraphicOptions{
 PrintObject: &enable,
 LockAspectRatio: false,
 OffsetX: 15,
 OffsetY: 10,
 Locked: &disable,
 }); err != nil {
 fmt.Println(err)
 }
 // Save the spreadsheet with the origin path.
 if err = f.Save(); err != nil {
 fmt.Println(err)
 }
}
```

## Contributing

Contributions are welcome! Open a pull request to fix a bug, or open an issue to discuss a new feature or change. XML is compliant with [part 1 of the 5th edition of the ECMA-376 Standard for Office Open XML](https://www.ecma-international.org/publications-and-standards/standards/ecma-376/).

## Licenses

This program is under the terms of the BSD 3-Clause License. See [https://opensource.org/licenses/BSD-3-Clause](https://opensource.org/licenses/BSD-3-Clause).

The Excel logo is a trademark of [Microsoft Corporation](https://aka.ms/trademarks-usage). This artwork is an adaptation.

gopher.{ai,svg,png} was created by [Takuya Ueda](https://twitter.com/tenntenn). Licensed under the [Creative Commons 3.0 Attributions license](http://creativecommons.org/licenses/by/3.0/).

excelize

Excel binding to struct written in Go.(Only supports Go1.18+)

# exl
Excel binding to struct written in Go.(Only supports Go1.18+)

[![CircleCI](https://circleci.com/gh/go-the-way/exl/tree/main.svg?style=shield)](https://circleci.com/gh/go-the-way/exl/tree/main)
![GitHub go.mod Go version](https://img.shields.io/github/go-mod/go-version/go-the-way/exl)
[![codecov](https://codecov.io/gh/go-the-way/exl/branch/main/graph/badge.svg?token=8MAR3J959H)](https://codecov.io/gh/go-the-way/exl)
[![Go Report Card](https://goreportcard.com/badge/github.com/go-the-way/exl)](https://goreportcard.com/report/github.com/go-the-way/exl)
[![GoDoc](https://pkg.go.dev/badge/github.com/go-the-way/exl?status.svg)](https://pkg.go.dev/github.com/go-the-way/exl?tab=doc)
[![Mentioned in Awesome Go](https://awesome.re/mentioned-badge.svg)](https://github.com/avelino/awesome-go#microsoft-excel)

## usage

### Read Excel

```go
package main

import (
	"fmt"
	
	"github.com/go-the-way/exl"
)

type ReadExcel struct {
	ID   int    `excel:"ID"`
	Name string `excel:"Name"`
}

func (*ReadExcel) ReadConfigure(rc *exl.ReadConfig) {}

func main() {
	if models, err := exl.ReadFile[*ReadExcel]("/to/path.xlsx"); err != nil {
		fmt.Println("read excel err:" + err.Error())
	} else {
		fmt.Printf("read excel num: %d\n", len(models))
	}
}
```

### Write Excel

```go
package main

import (
	"fmt"
	
	"github.com/go-the-way/exl"
)

type WriteExcel struct {
	ID   int    `excel:"ID"`
	Name string `excel:"Name"`
}

func (m *WriteExcel) WriteConfigure(wc *exl.WriteConfig) {}

func main() {
	if err := exl.Write("/to/path.xlsx", []*WriteExcel{{100, "apple"}, {200, "pear"}}); err != nil {
		fmt.Println("write excel err:" + err.Error())
	} else {
		fmt.Println("write excel done")
	}
}
```

## Writer

```go
package main

import (
	"fmt"

	"github.com/go-the-way/exl"
)

func main() {
	w := exl.NewWriter()
	if err := w.Write("int", []int{1, 2}); err != nil {
		fmt.Println(err)
		return
	}
	if err := w.Write("float", []float64{1.1, 2.2}); err != nil {
		fmt.Println(err)
		return
	}
	if err := w.Write("string", []string{"hello", "world"}); err != nil {
		fmt.Println(err)
		return
	}
	if err := w.Write("map", []map[string]string{{"id":"1000","name":"hello"},{"id":"2000","name":"world"}}); err != nil {
		fmt.Println(err)
		return
	}
	if err := w.Write("structWithField", []struct{ID int}{{1000},{2000}}); err != nil {
		fmt.Println(err)
		return
	}
	if err := w.Write("structWithTag", []struct{ID int `excel:"编号"`}{{1000},{2000}}); err != nil {
		fmt.Println(err)
		return
	}
	if err := w.Write("structWithTagAndIgnore", []struct{
		ID int `excel:"编号"`
		Extra int `excel:"-"`
		Name string `excel:"名称"`
	}{{1000,0,"Coco"},{2000,0,"Apple"}}); err != nil {
		fmt.Println(err)
		return
	} 
	if err := w.SaveTo("dist.xlsx"); err != nil {
		fmt.Println(err)
		return
	}
}
```


The Best Go Libraries For Microsoft Office - Libraries for working with Microsoft Excel. (2)

excelize

exl