-
Notifications
You must be signed in to change notification settings - Fork 8
/
basic.go
56 lines (50 loc) · 1.47 KB
/
basic.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
// Copyright 2022 exl Author. All Rights Reserved.
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
// http://www.apache.org/licenses/LICENSE-2.0
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
package exl
import (
"github.com/tealeg/xlsx/v3"
)
// ReadExcel defines read walk func from excel
//
// params: file, excel file pull path
//
// params: sheetIndex, current sheet index
//
// params: walk, walk func
func ReadExcel(file string, sheetIndex int, walk func(index int, rows *xlsx.Row)) error {
f, err := xlsx.OpenFile(file)
if err != nil {
return err
}
sheet := f.Sheets[sheetIndex]
for i := 0; i < sheet.MaxRow; i++ {
if row, _ := sheet.Row(i); row != nil {
walk(i, row)
}
}
return nil
}
// WriteExcel defines write [][]string to excel
//
// params: file, excel file pull path
//
// params: data, write data to excel
func WriteExcel(file string, data [][]string) error {
f := xlsx.NewFile()
sheet, _ := f.AddSheet("Sheet1")
for _, row := range data {
r := sheet.AddRow()
for _, cell := range row {
r.AddCell().SetString(cell)
}
}
return f.Save(file)
}