Golang library for reading and writing Microsoft Excel (XLSX) files.
Go
Permalink
Failed to load latest commit information.
test Support add picture with offset and scaling. Jan 22, 2017
.travis.yml Update test file. Aug 30, 2016
LICENSE - New function `AddPicture()` added, support to add picture into exce… Jan 17, 2017
README.md Update README, godoc and fix typo. Jan 22, 2017
cell.go - Add hyperlink and set formula support for cell support; Jan 19, 2017
col.go Support add picture with offset and scaling. Jan 22, 2017
excelize.go - Add hyperlink and set formula support for cell support; Jan 19, 2017
excelize.png Init commit. Aug 30, 2016
excelize_test.go Support add picture with offset and scaling. Jan 22, 2017
file.go Format commants, break comments after 80 characters. Jan 18, 2017
lib.go Format commants, break comments after 80 characters. Jan 18, 2017
picture.go Update README, godoc and fix typo. Jan 22, 2017
rows.go Format commants, break comments after 80 characters. Jan 18, 2017
sheet.go Update README, godoc and fix typo. Jan 22, 2017
templates.go Update godoc of package. Oct 19, 2016
xmlContentTypes.go - New function `AddPicture()` added, support to add picture into exce… Jan 17, 2017
xmlDecodeDrawing.go Format commants, break comments after 80 characters. Jan 18, 2017
xmlDrawing.go Support add picture with offset and scaling. Jan 22, 2017
xmlSharedStrings.go Format commants, break comments after 80 characters. Jan 18, 2017
xmlWorkbook.go - Add hyperlink and set formula support for cell support; Jan 19, 2017
xmlWorksheet.go Format commants, break comments after 80 characters. Jan 18, 2017

README.md

Excelize

Excelize

Build Status Code Coverage Go Report Card GoDoc Licenses Join the chat at https://gitter.im/xuri-excelize/Lobby

Introduction

Excelize is a library written in pure Golang and providing a set of functions that allow you to write to and read from XLSX files. Support reads and writes XLSX file generated by Office Excel 2007 and later. Support save file without losing original charts of XLSX. The full API docs can be seen using go's built-in documentation tool, or online at godoc.org.

Basic Usage

Installation

go get github.com/Luxurioust/excelize

Create XLSX file

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

package main

import (
    "fmt"
    "os"

    "github.com/Luxurioust/excelize"
)

func main() {
    xlsx := excelize.CreateFile()
    // Create a new sheet.
    xlsx.NewSheet(2, "Sheet2")
    // Set int or string type value of a cell.
    xlsx.SetCellValue("Sheet2", "A2", "Hello world.")
    xlsx.SetCellValue("Sheet1", "B2", 100)
    // Set active sheet of workbook.
    xlsx.SetActiveSheet(2)
    // Save xlsx file by the given path.
    err := xlsx.WriteTo("/tmp/Workbook.xlsx")
    if err != nil {
        fmt.Println(err)
        os.Exit(1)
    }
}

Reading XLSX file

The following constitutes the bare to read a XLSX document.

package main

import (
    "fmt"
    "os"

    "github.com/Luxurioust/excelize"
)

func main() {
    xlsx, err := excelize.OpenFile("/tmp/Workbook.xlsx")
    if err != nil {
        fmt.Println(err)
        os.Exit(1)
    }
    // Get value from cell by given sheet index and axis.
    cell := xlsx.GetCellValue("Sheet1", "B2")
    fmt.Println(cell)
    // Get all the rows in a sheet.
    rows := xlsx.GetRows("Sheet2")
    for _, row := range rows {
        for _, colCell := range row {
            fmt.Print(colCell, "\t")
        }
    }
    // Save the xlsx file with origin path.
    err = xlsx.Save()
    if err != nil {
        fmt.Println(err)
        os.Exit(1)
    }
}

Add picture to XLSX file

package main

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

    "github.com/Luxurioust/excelize"
)

func main() {
    xlsx := excelize.CreateFile()
    // Insert a picture.
    err := xlsx.AddPicture("Sheet1", "A2", "/tmp/image1.gif", 0, 0, 1, 1)
    // Insert a picture to sheet with scaling.
    err = xlsx.AddPicture("Sheet1", "D2", "/tmp/image2.jpg", 0, 0, 0.5, 0.5)
    // Insert a picture offset in the cell.
    err = xlsx.AddPicture("Sheet1", "H2", "/tmp/image3.png", 15, 10, 1, 1)
    if err != nil {
        fmt.Println(err)
        os.Exit(1)
    }
    err = xlsx.WriteTo("/tmp/Workbook.xlsx")
    if err != nil {
        fmt.Println(err)
        os.Exit(1)
    }
}

Contributing

Contributions are welcome! Open a pull request to fix a bug, or open an issue to discuss a new feature or change.

Credits

Some struct of XML originally by tealeg/xlsx.

Licenses

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