Excelize: Golang library for reading and writing Microsoft Excel™ (XLSX) files.
Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLSX files. Supports reading and writing XLSX file generated by Microsoft Excel™ 2007 and later. Supports saving a file without losing original charts of XLSX. This library needs Go version 1.10 or later. The full API docs can be seen using go’s built-in documentation tool, or online at godoc.org and docs reference.
Installation
go get github.com/360EntSecGroup-Skylar/excelize
Reading XLSX file
package main
import "github.com/360EntSecGroup-Skylar/excelize"
func main() {
f, err := excelize.OpenFile("Book1.xlsx")
if err != nil {
println(err.Error())
return
}
cell, err := f.GetCellValue("Sheet1", "B2")
if err != nil {
println(err.Error())
return
}
println(cell)
rows, err := f.GetRows("Sheet1")
for _, row := range rows {
for _, colCell := range row {
print(colCell, "\t")
}
println()
}
}