Breaking News: Grepper is joining You.com. Read the official announcement!

read a spreadsheet (Excel) document by Golang (Go) Excelize

xuri answered on December 16, 2021 Popularity 1/10 Helpfulness 1/10

answer read a spreadsheet (Excel) document by Golang (Go) Excelize

read a spreadsheet (Excel) document by Golang (Go) Excelize

Comment

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 axis.
    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()
    }
}

Popularity 1/10 Helpfulness 1/10 Language go

Source: github.com

Tags: document excelize go spreadsheet

Link to this answer
Share Copy Link

Contributed on Dec 16 2021

xuri

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

read a spreadsheet (Excel) document by Golang (Go) Excelize

Contents

More Related Answers

read a spreadsheet (Excel) document by Golang (Go) Excelize

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.