golang-导出xlsx_敲代码的疯猫_新浪博客

导出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)

}