1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| var userList []User
var file = xlsx.NewFile()
sheet, err := file.AddSheet("工作簿1")
var headRow = sheet.AddRow() headRow.AddCell().Value = "Username" headRow.AddCell().Value = "Password"
for _, user := range userList { var contentRow = sheet.AddRow() contentRow.AddCell().SetValue(user.Username) contentRow.AddCell().SetValue(user.Password) }
var fileName = fmt.Sprintf("%d.xlsx", time.Now().Unix()) var filePath = filepath.Join(os.TempDir(), fileName) err := file.Save(filePath)
|