go操作excel单元格合并

1、下载xlsx包

go get -u github.com/tealeg/xlsx

2.新建excel并写入数据部分代码

file := xlsx.NewFile()
sheet, err := file.AddSheet("标签页1")
if err != nil {
    fmt.Printf(err.Error())
}
//设置表格标题
title := sheet.AddRow()
titleRow := title.AddCell()
titleRow.HMerge = 11 //向右合并列数，不包括自身列
titleRow.Value = "this is excel title"

header1 := sheet.AddRow()
header2 := sheet.AddRow()

span1 := header1.AddCell()
header2.AddCell()
span1.VMerge = 1
span1.Value = "向下合并的单元格"

span2 := header1.AddCell()
header2.AddCell()
span2.VMerge = 1
span2.Value = "向下合并的单元格"


span3 := header1.AddCell()
header1.AddCell()
span3.HMerge = 1
span3.Value = "向右合并的单元格"
span4 := header2.AddCell()
span4.Value = "子单元格-1"
span5 := header2.AddCell()
span5.Value = "子单元格-2"


span6 := header1.AddCell()
span7 := header2.AddCell()
span6.Value = "单元格6"
span7.Value = "单元格7"


file.Save("/1.xlsx")

3.示例结果