func getHeader(sheet *xlsx.Sheet) (*tool.ExportHeaderV1, error) {
headerString := strings.TrimSpace(sheet.Cell(0, 0).Value)
// 可能是空的sheet
if headerString == "" {
return nil, nil
}
var header tool.ExportHeaderV1
// 有可能的字符,一定是头
if strings.Contains(headerString, "ProtoTypeName") ||
strings.Contains(headerString, "RowFieldName") {
if err := proto.UnmarshalText(headerString, &header); err != nil {
return nil, err
}
} else {
// 有字符, 但并不是头
return nil, nil
}
return &header, nil
}
//AddCell sheet
func AddCell(sheet *xlsx.Sheet, row, col int) *xlsx.Cell {
// hhh
for row >= len(sheet.Rows) {
sheet.AddRow()
}
for col >= len(sheet.Rows[row].Cells) {
sheet.Rows[row].AddCell()
}
return sheet.Cell(row, col)
}
func getHeader(sheet *xlsx.Sheet) *tool.ExportHeader {
headerString := sheet.Cell(0, 0).Value
var header tool.ExportHeader
if err := proto.UnmarshalText(headerString, &header); err != nil {
return nil
}
return &header
}
