golang 實現對excel的操作

這是一個建立於 的文章，其中的資訊可能已經有所發展或是發生改變。

讀excel操作

import ( "fmt" "github.com/tealeg/xlsx")func main() { excelFileName := "這裡是excel的路徑" xlFile, error := xlsx.OpenFile(excelFileName) if error != nil { ... } for _, sheet := range xlFile.Sheets { for _, row := range sheet.Rows { for _, cell := range row.Cells { fmt.Printf("%s\n", cell.String()) } } }}

123456789101112131415161718

import (    "fmt"    "github.com/tealeg/xlsx")func main() {    excelFileName := "這裡是excel的路徑"    xlFile, error := xlsx.OpenFile(excelFileName)    if error != nil {        ...    }    for _, sheet := range xlFile.Sheets {        for _, row := range sheet.Rows {            for _, cell := range row.Cells {                fmt.Printf("%s\n", cell.String())            }        }    }}

 

寫入excel：

package mainimport ( "os" "encoding/csv")func main() { f, err := os.Create("test.xls") if err != nil { panic(err) } defer f.Close() f.WriteString("\xEF\xBB\xBF") // 寫入UTF-8 BOM w := csv.NewWriter(f) w.Write([]string{"編號","姓名","年齡"}) w.Write([]string{"1","張三","23"}) w.Write([]string{"2","李四","24"}) w.Write([]string{"3","王五","25"}) w.Write([]string{"4","趙六","26"}) w.Flush()}

12345678910111213141516171819

package mainimport (    "os"    "encoding/csv")func main() {    f, err := os.Create("test.xls")    if err != nil {        panic(err)    }    defer f.Close()    f.WriteString("\xEF\xBB\xBF") // 寫入UTF-8 BOM    w := csv.NewWriter(f)    w.Write([]string{"編號","姓名","年齡"})    w.Write([]string{"1","張三","23"})    w.Write([]string{"2","李四","24"})    w.Write([]string{"3","王五","25"})    w.Write([]string{"4","趙六","26"})    w.Flush()}

 

 

golang 實現對excel的操作