07-流式写入

合集 - 【SDK卷】-----------------------------(24)

1.strings包2022-07-302.envconfig包（读取环境变量）2022-05-123.gocron包（定时任务）2023-01-044.go-redis包2023-03-145.net/http包实战2022-05-026.net/http包Client的使用2022-05-107.01-判断正则匹配、判断正则合法性2022-06-188.02-查找正则匹配字串、查找正则匹配字串的位置2022-06-199.03-查找匹配字串，查找匹配字串位置，正则分组2022-06-2010.04-使用正则替换2022-06-2211.06-其他用法2022-06-2512.01-注释、作用域、空格和空行、管道2022-08-2913.02-变量、if语句、迭代、内置函数2022-08-3114.01-入门示例、工作簿、文件Writer2022-09-0415.02-工作表操作2022-09-0816.03-行和列操作2022-09-1317.04-迭代器2022-09-1618.05-单元格操作2022-09-2719.06-样式设置2022-09-29

20.07-流式写入2022-10-21

21.01-Gauge（仪表盘）2022-08-0822.02-Counter（计数器）2022-08-0923.03-HIstogram（直方图）2022-08-2224.04-Summary（摘要）2022-08-21

收起

目录

• 1. 创建流式写入器
• 2. 按行流式写入工作表
• 3. 流式创建表格
• 4. 结束流式写入
• 5. 流式合并单元格
• 6. 流式设置列宽
• 7. 完整示例
  • 示例1
  • 示例2

1. 创建流式写入器

• 语法

func (f *File) NewStreamWriter(sheet string) (*StreamWriter, error)

• 语法示例

	f := excelize.NewFile()
	sw,_ := f.NewStreamWriter("Sheet1")

2. 按行流式写入工作表

func (sw *StreamWriter) SetRow(axis string, slice interface{}) error

3. 流式创建表格

func (sw *StreamWriter) AddTable(hCell, vCell, format string) error

4. 结束流式写入

func (sw *StreamWriter) Flush() error

5. 流式合并单元格

func (sw *StreamWriter) MergeCell(hCell, vCell string) error

6. 流式设置列宽

func (sw *StreamWriter) SetColWidth(min, max int, width float64) error

7. 完整示例

示例1

• 代码

package main
 
package main
 
import (
	"github.com/xuri/excelize/v2"
)
 
func main() {
	f := excelize.NewFile()
	sw,_ := f.NewStreamWriter("Sheet1")
	rowValues1 := []interface{}{"LiuBei","GuanYu","Zhangfei"}
	sw.SetRow("A1",rowValues1)
	rowValues2 := []interface{}{"LiuBei","GuanYu","Zhangfei"}
	sw.SetRow("A2",rowValues2)
	sw.Flush()
	f.SaveAs("liuBei.xlsx")
}

• 结果显示
  

示例2

• 代码

package main
 
import (
	"fmt"
	"github.com/xuri/excelize/v2"
	"strconv"
)
 
func main() {
	f := excelize.NewFile()
	sw,_ := f.NewStreamWriter("Sheet1")
	for i:=2;i<=99;i++ {
		rowN := "A"+strconv.Itoa(i)
		fmt.Println(rowN)
		rowValues := []interface{}{"LiuBei","GuanYu","Zhangfei"}
		sw.SetRow(rowN,rowValues)
	}
	sw.Flush()
	f.SaveAs("liuBei.xlsx")
}

---