我正在使用 excelize 包裝來操作 excel 文件。我對 setcellformula 函數(shù)有疑問,它不應用公式。我粘貼了一個基本示例,我只是在嘗試func main() { f := excelize.NewFile() f.SetCellValue("Sheet1", "A1", "ID") f.SetCellValue("Sheet1", "B1", "Nome") f.SetCellValue("Sheet1", "D1", "Cognome") f.SetCellValue("Sheet1", "C1", "Email") f.SetCellValue("Sheet1", "D1", "IDENTITY_CARD_EXPIRE_DATE") f.SetCellValue("Sheet1", "E1", "TOTAL") f.SetCellValue("Sheet1", "E2", "1") f.SetCellValue("Sheet1", "E3", "5") f.SetCellValue("Sheet1", "E4", "10") //formula f.SetCellFormula("Sheet1", "E6", "=SUBTOTALE(9;E2:E8)") f.SetColWidth("Sheet1", "A", "D", 30) if err := f.SaveAs("Personal_Data.xlsx"); err != nil { log.Fatal(err) }}謝謝你們
Excelize pkg.go Golang
慕桂英3389331
2022-12-19 20:22:03