goxls

goxls

xls package use to parse the 97-2004 microsoft xls file(".xls" suffix, NOT ".xlsx" suffix )

code forked from extrame/xls and fix the test.

demo usage

Watch your step: i <= int(sheet.MaxRow).

import (
	"fmt"
	"github.com/bingoohuang/goxls/pkg/xls"
)

func main() {
	xlFile, _ := xls.Open("example.xls", "utf-8")
	sheet := xlFile.GetSheet(0)
    
	for i := 0; i <= int(sheet.MaxRow); i++ {
		row := sheet.Row(i)
		fmt.Println("row", i + 1, "col 1", row.Col(0))
		fmt.Println("row", i + 1, "col 2", row.Col(1))
	}
}

cmd usage

go get github.com/bingoohuang/goxls/cmd/goxls

🕙[2020-08-04 10:29:18.609] ❯ goxls                                                                                 
  -file string
        read excel file(.xls suffix)
  -xlsx string
        comparing excel file(.xlsx suffix)
🕙[2020-08-04 10:28:31.748] ❯ goxls -file example.xls     
NumSheets: 1
Sheets: 0, Name: Table, TotalRows: 12
Row 1
Col 1: "Code"
Col 2: "Name"
Col 3: "Description"
Col 4: ""
🕙[2020-08-04 10:28:45.722] ❯ goxls -file a.xls -xlsx a.xlsx
numOfSheets: 1
sheet index: 0, name: sheet1, total rows: 16
there is no difference between two files

resources

1. github topics xls