代码片段如下:
package utils
import (
"github.com/360EntSecGroup-Skylar/excelize"
log "github.com/sirupsen/logrus"
)
func CreateExcelFile(sheetName, filePath string, data map[string]string) error {
xlsx := excelize.NewFile()
index := xlsx.NewSheet(sheetName)
for k, v := range data {
xlsx.SetCellValue(sheetName, k, v)
}
xlsx.SetActiveSheet(index)
SaveAsErr := xlsx.SaveAs(filePath)
if SaveAsErr != nil {
log.WithFields(log.Fields{"error": SaveAsErr}).Warn("Excel")
return SaveAsErr
}
return nil
}
func ReadExcelFile(sheetName, filePath string) [][]string {
excelFile, OpenFileErr := excelize.OpenFile(filePath)
if OpenFileErr != nil {
log.WithFields(log.Fields{"error": OpenFileErr}).Warn("Excel")
return nil
}
return excelFile.GetRows(sheetName)
}