Golang excel 封装导出功能

最新推荐文章于 2025-06-03 11:57:42 发布

原创最新推荐文章于 2025-06-03 11:57:42 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个使用Golang实现的Excel数据导出函数，该函数能够将数据库查询结果转换为Excel文件，支持多种数据类型，包括字符串、整型和浮点数，并能自动生成带有样式的工作表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package myutils

import (
	"feinail/of_capital/config"
	"fmt"
	"github.com/jinzhu/gorm"
	"github.com/tealeg/xlsx"
	"strconv"
	"time"
)

func ExcelExportData(db *gorm.DB, config config.Config, header []interface{}, data [][]interface{}, sheetName string) string {
	timeStr := time.Now().Format("2006-01-02 15:04:05")
	var file *xlsx.File
	var sheet *xlsx.Sheet
	var row *xlsx.Row
	var cell *xlsx.Cell

	style := &xlsx.Style{}
	style.Fill = *xlsx.NewFill("solid", "EFEFDE", "EFEFDE")
	style.Border = xlsx.Border{RightColor: "FF"}
	file = xlsx.NewFile()
	sheet, _ = file.AddSheet(sheetName)
	row = sheet.AddRow()
	for _, head := range header { //looping from 0 to the length of the array
		cell = row.AddCell()
		cell.Value = head.(string)
		cell.SetStyle(style)
	}
	for _, obj := range data {
		fmt.Println(obj)
		row = sheet.AddRow()
		for _, value := range obj {
			switch value.(type) {
			case string:
				value = value
				break
			case int:
				value = strconv.Itoa(value.(int))
				break
			case float64:
				value = strconv.FormatFloat(value.(float64), 'f', -1, 64)
				break
			}

			cell = row.AddCell()
			cell.Value = value.(string)
		}
	}
	url := config.ExcelPath + timeStr + ".xlsx"
	file.Save(url)
	return url
}

func To2Array(params []interface{}) [][]interface{} {
	var content_arr [][]interface{}
	for _, param := range params {
		var col []interface{}
		for _, p := range param.([]interface{}) {
			col = append(col, p.(interface{}))
		}
		content_arr = append(content_arr, col)
	}
	return content_arr
}






content := ReqParams["content"].([]interface{})
content_arr2 := myutils.To2Array(content)
rs := myutils.ExcelExportData(db, config, ReqParams["header"].([]interface{}), content_arr2, ReqParams["sheet_name"].(string))