How to quickly match xlsx file row and struct fields

[moluzhui]

I have a struct that maps mysql database tables, some fields are required and some are optional

type TestObj struct{
    Test0 string   gorm:"column:test0" // Required fields
    Test1 string   gorm:"column:test1" // Required fields
    Test2 string   gorm:"column:test2" // Optional
    Test3 string   gorm:"column:test3" // Optional
    Test4 string   gorm:"column:test4" // Optional
}

I parse and store in the database in batches as follows

import (
    "github.com/xuri/excelize/v2"
)
file, _, err := c.Request.FormFile("file")
if err != nil {
    return
}
xlsx, err := excelize.OpenReader(f)
if err != nil {
    return err
}
defer func() {
    if err := xlsx.Close(); err != nil {
        log.L(c).Info(err.Error())
    }
}()
rows, err := xlsx.GetRows(xlsx.GetSheetName(xlsx.GetActiveSheetIndex()))
if err != nil {
    fmt.Println(err)
    return nil, err
}
objs := []TestObj{}
for i, row := range rows {
    if i == 0{     // 
        continue
    }
    data := TestObj{
        Test0: row[0]
        Test1: row[1]
        Test2: row[2]
        Test3: row[3]
        Test4: row[4]
    }
    objs= append(objs, data)
}
service.BatchInsert(c,objs) // batch insert into mysql

However, this method binds the relative order of the columns of the excel file. If I need to enter the data of Test0, Test1, and Test4, I still have to create a five-column excel file, in which the third and fourth columns are empty, to make sure it is correct.

Is there any other convenient way to do field matching?

[xuri]

Thanks for your feedback. This is similar to issue #619, #1208. Currently, you need to convert the input to the Excelize required data types by yourself.