[golnag] 기초 excelize

Golang excelize 를 이용해서 excel 파일 일기

---

go get github.com/360EntSecGroup-Skylar/excelize

---

package main

import (
	"fmt"
	"log"

	"github.com/360EntSecGroup-Skylar/excelize"
)

func main() {
	xlsx, err := excelize.OpenFile("./test.xlsx")

	if err != nil {
		panic(err)
	}

	// sheet name
	activeSheet := xlsx.GetActiveSheetIndex()
	activeSheetName := xlsx.GetSheetName(activeSheet)

	// get value (시트명, 셀위치)
	log.Println(xlsx.GetCellValue(activeSheetName, "A2"))

	// get rows (시트명으로)
	rows := xlsx.GetRows(activeSheetName)

	for _, row := range rows {
		for _, colCell := range row {
			fmt.Print(colCell, "\t")
		}
		fmt.Println()
	}
}

결과는 요렇게 ..

1       20      21
2       21      23
3       22      25
4       23      27
5       24      29
6       25      31
7       26      33
8       27      35
9       28      37

안녕~