2024-06-20 15:33:14 +08:00
|
|
|
package xlsx
|
|
|
|
|
|
|
|
import (
|
|
|
|
"fmt"
|
|
|
|
"testing"
|
|
|
|
"time"
|
|
|
|
|
|
|
|
"git.botann.com/lijun/xlsx/imports"
|
|
|
|
)
|
|
|
|
|
|
|
|
type Data struct {
|
|
|
|
Autoseq int
|
|
|
|
Name string `import:"true,index:1"`
|
|
|
|
Unit string `import:"true,index:2"`
|
|
|
|
TestCol string
|
|
|
|
Invest int64 `import:"true,index:3"`
|
|
|
|
CreateTime time.Time `import:"true,index:4"`
|
|
|
|
}
|
|
|
|
|
|
|
|
func TestMain(t *testing.T) {
|
|
|
|
var data []Data
|
2024-10-23 13:18:58 +08:00
|
|
|
importer, err := imports.NewFileImporter("./test7.xlsx", &data, 2)
|
2024-06-20 15:33:14 +08:00
|
|
|
if err != nil {
|
|
|
|
fmt.Println(err)
|
|
|
|
}
|
|
|
|
err = importer.Import(0)
|
|
|
|
if err != nil {
|
|
|
|
fmt.Println(err)
|
|
|
|
}
|
|
|
|
fmt.Println(data)
|
|
|
|
}
|