golang数组生成excel

package main
import (
	"strconv"
	"github.com/Luxurioust/excelize"
)

func main() {
	//go get github.com/360EntSecGroup-Skylar/excelize
	xlsxNew := excelize.NewFile()
	newSheet := "Sheet1"
	xlsxNew.NewSheet(newSheet)

	result := [5][5]int{{1,2,3,4,5},{1,2,3,4,5},{1,2,3,4,5},{1,2,3,4,5},{1,2,3,4,5}}

	for i, row := range result {
		//fmt.Printf("i:%d,",i)
		for j, colCell := range row {
			//fmt.Printf("j:%d",j)
			zuobiao := ChangIndexToAxis(i, j)
			ModifyExcelCellByAxis(xlsxNew, newSheet, zuobiao, colCell)
			//fmt.Print(colCell, ",")
		}
	}
	xlsxNew.SaveAs("./你要的表格.xlsx")
}


/*
 * Title : 数组下标转换成excel坐标
 * Author : weiweiabc109@163.com
 * Date : 2018-04-06
 */
func ChangIndexToAxis (intIndexX int,intIndexY int ) string{
	var arr = [...]string{"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"}
	intIndexY = intIndexY+1
	resultY := ""
	for true {
		if intIndexY <= 26 {
			resultY = resultY + arr[intIndexY-1]
			break
		}
		mo := intIndexY % 26
		resultY = arr[mo-1] + resultY
		shang := intIndexY/26
		if shang <= 26 {
			resultY = arr[shang-1] + resultY
			break
		}
		intIndexY = shang
	}
	return resultY+strconv.Itoa(intIndexX+1)
}

/*
 * Title : 修改excel表格里的值
 * Author : weiweiabc109@163.com
 * Date : 2018-04-06
 */
func ModifyExcelCellByAxis( xlsx *excelize.File,sheet string, axis string, value interface{}) int{
	xlsx.SetCellValue(sheet, axis, value)
	return 0
}

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值