55 lines
937 B
Go
55 lines
937 B
Go
package lib
|
|
|
|
import (
|
|
"testing"
|
|
)
|
|
|
|
func TestNewExcel(t *testing.T) {
|
|
content := make([]interface{}, 0)
|
|
|
|
for i := 0; i < 2; i++ {
|
|
content = append(content, []interface{}{
|
|
"戴恒顺", i + 1 + 1,
|
|
})
|
|
}
|
|
excel := NewExcel(WithExcelName("测试"), WithExcelSheet("专家信息"),
|
|
WithExcelHeader("人员信息"),
|
|
WithExcelTitle([]string{"姓名", "年龄"}), WithExcelContent(&ExcelContent{
|
|
Kind: 0,
|
|
Content: content,
|
|
}))
|
|
err := excel.Export()
|
|
|
|
if err != nil {
|
|
t.Log(err)
|
|
return
|
|
}
|
|
err = excel.Save("./lib")
|
|
t.Log(err)
|
|
}
|
|
|
|
type Data struct {
|
|
Name string `json:"name" xlsx:"姓名"`
|
|
Age int `json:"age" xlsx:"年龄"`
|
|
}
|
|
|
|
func TestNewExcelImport(t *testing.T) {
|
|
excel := NewExcel()
|
|
|
|
err := excel.Import("测试.xlsx", 1, 0)
|
|
|
|
if err != nil {
|
|
t.Log(err)
|
|
return
|
|
}
|
|
data := excel.Analysis(&Data{})
|
|
|
|
t.Log(len(data))
|
|
|
|
for _, v := range data {
|
|
_data, ok := v.(*Data)
|
|
t.Log(ok)
|
|
t.Log(_data)
|
|
}
|
|
}
|