导出xlsx
导出表格有两种方式,一种是直接导出,一种是导出到模板表格.
1.....
import("github.com/tealeg/xlsx")
func (c *XlxsController) Get(){
var file *xlsx.File
var sheet *xlsx.Sheet
var row *xlsx.Row
var cell *xlsx.Cell
var err error
var user models.User
sql := "SELECT * FROM user"
ss, err := user.OrmRaws(sql)
if err != nil {
fmt.Println("chucuo")
} else {
fmt.Println(ss)
}
file = xlsx.NewFile()
sheet, err = file.AddSheet("账户密码")
if err != nil {
fmt.Printf(err.Error())
}
for _, v := range ss {
row = sheet.AddRow()
cell = row.AddCell()
cell.Value = strconv.Itoa(v.Username)
cell = row.AddCell()
cell.Value = v.Userpass
}
err = file.Save("账户密码.xlsx")
if err != nil {
fmt.Printf(err.Error())
}
}
2.......在表格中先建好两列,账户和密码
var user models.User
sql := "SELECT * FROM user"
ss, err := user.OrmRaws(sql)
if err != nil {
fmt.Println("chucuo")
} else {
fmt.Println(ss)
}
file, err := xlsx.OpenFile("aa.xlsx")
if err != nil {
panic(err)
}
first := file.Sheets[0]
for _, v := range ss {
row := first.AddRow()
row.SetHeightCM(1)
cell := row.AddCell()
cell.Value = strconv.Itoa(v.Username)
cell = row.AddCell()
cell.Value = v.Userpass
}
err = file.Save("file.xlsx")
if err != nil {
panic(err)
}