xls|pdf

• xlsx文件处理 github.com/tealeg/xlsx
  https://github.com/unidoc/unioffice
  https://github.com/unidoc/unipdf
  ~
  //写文件
  file:= xlsx.NewFile()
  sheet, err := file.AddSheet(“Sheet1”)
  if err != nil {

    fmt.Printf(err.Error())

  }
  row := sheet.AddRow()
  row.AddCell().Value=”你好”
  row.AddCell().Value=”中国”

  row1 := sheet.AddRow()
  row1.AddCell().Value=”你好”
  row1.AddCell().Value=”中国”

  file.Save(“2.xlsx”)
  //读取文件
  for _, sheet := range xls.Sheets {

    fmt.Printf("表名: %s", sheet.Name)
    for _, row := range sheet.Rows {
        fmt.Println("")
        for _, cell := range row.Cells {//切片
            fmt.Printf("%s\t", cell.String())
        }
    }

  }
  //修改
  xls, err := xlsx.OpenFile(“2.xlsx”)
  if err != nil {
  panic(err)
  }
  first := xls.Sheets[0]
  rowx:= first.AddRow()
  rowx.AddCell().Value=”测试”
  xls.Save(“3.xlsx”)

- `github.com/360EntSecGroup-Skylar/excelize`
_ "image/gif"
    _ "image/jpeg"
    _ "image/png"

写文件
f := excelize.NewFile()
index := f.NewSheet(“Sheet2”)
f.SetActiveSheet(index)//激活当前
f.SetCellValue(“Sheet2”, “A2”, “你好吗”)
f.SetCellValue(“Sheet1”, “B2”, 100)
f.AddPicture(“Sheet1”, “A2”, “ad.png”, {"x_scale": 0.5, "y_scale": 0.5});
f.SaveAs(“Book1.xlsx”)

//读文件
f, err := excelize.OpenFile("book1.xlsx")
if err != nil {
    fmt.Println(err)
    return
}
cell:= f.GetCellValue("Sheet1", "B2")//读取一个单元
fmt.Println(cell)
rows := f.GetRows("Sheet1")//返回切片
fmt.Println(rows)

~