golang数据写入.csv文件和.excel文件

1.  
   package main
2.  
    
3.  
   import (
4.  
   "fmt"
5.  
   "os"
6.  
   "strconv"
7.  
   "strings"
8.  
   "sync"
9.  
   "time"
10.  
     
11.  
    "github.com/xuri/excelize/v2"
12.  
    )
13.  
     
14.  
    var wg sync.WaitGroup
15.  
     
16.  
    func main() {
17.  
    wg.Add(2)
18.  
    go writeToCsv()
19.  
    go writeToExcelDirectly()
20.  
    wg.Wait()
21.  
    }
22.  
     
23.  
    func writeToCsv() {
24.  
    //数据写入到csv文件
25.  
    t1 := time.Now().UnixNano()
26.  
    //首行
27.  
    var titles string
28.  
    titles = "姓名，年龄，爱好\n"
29.  
     
30.  
    var stringBuilder strings.Builder
31.  
    stringBuilder.WriteString(titles)
32.  
     
33.  
    var i int
34.  
    for i = 0; i < 1000000; i {
35.  
    dataString := fmt.Sprintf("张三%d,%d,蹦极%d\n", i 1, i 1, i 1)
36.  
    stringBuilder.WriteString(dataString)
37.  
    }
38.  
    filename := "./test.csv"
39.  
    file, _ := os.OpenFile(filename, os.O_RDWR|os.O_CREATE, os.ModeAppend|os.ModePerm)
40.  
    dataString := stringBuilder.String()
41.  
    file.WriteString(dataString)
42.  
    file.Close()
43.  
     
44.  
    t2 := time.Now().UnixNano()
45.  
    t := t2 - t1
46.  
    fmt.Printf("writeToCsv总共%d条数据，总耗时%d毫秒\n", i, t/1000000)
47.  
    wg.Done()
48.  
    }
49.  
     
50.  
    func writeToExcelDirectly() {
51.  
    //数据写入到excel文件
52.  
    t1 := time.Now().UnixNano()
53.  
     
54.  
    f := excelize.NewFile()
55.  
    defer f.Close()
56.  
     
57.  
    // 创建一个工作表
58.  
    index := f.NewSheet("Sheet1")
59.  
     
60.  
    // 设置单元格的值
61.  
    f.SetCellValue("Sheet1", "A1", "姓名")
62.  
    f.SetCellValue("Sheet1", "B1", "年龄")
63.  
    f.SetCellValue("Sheet1", "C1", "爱好")
64.  
    var indexA, indexB, indexC string
65.  
    var i int
66.  
    for i = 0; i < 10000; i {
67.  
    indexA = fmt.Sprintf("A%v", i 2)
68.  
    indexB = fmt.Sprintf("B%v", i 2)
69.  
    indexC = fmt.Sprintf("C%v", i 2)
70.  
    f.SetCellValue("Sheet1", indexA, "张三" strconv.Itoa(i))
71.  
    f.SetCellValue("Sheet1", indexB, i)
72.  
    f.SetCellValue("Sheet1", indexC, "游泳" strconv.Itoa(i))
73.  
    }
74.  
     
75.  
    // 设置工作簿的默认工作表
76.  
    f.SetActiveSheet(index)
77.  
     
78.  
    // 根据指定路径保存文件
79.  
    name := "test.xlsx"
80.  
    if err := f.SaveAs(name); err != nil {
81.  
    panic(err)
82.  
    }
83.  
     
84.  
    t2 := time.Now().UnixNano()
85.  
    t := t2 - t1
86.  
    fmt.Printf("writeToExcelDirectly总共%d条数据，总耗时%d毫秒\n", i, t/1000000)
87.  
    wg.Done()
88.  
    }

这篇好文章是转载于：学新通技术网