1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| // @Title: Excel 表中某个范围内的单元格 (Cells in a Range on an Excel Sheet)
// @Author: 15816537946@163.com
// @Date: 2022-03-06 10:51:12
// @Runtime: 4 ms
// @Memory: 3.2 MB
func cellsInRange(s string) []string {
ps := strings.Split(s, ":")
a := ps[0]
b := ps[1]
ret := make([]string, 0)
for i := a[0]; b[0] >= i; i++ {
for j := a[1]; b[1] >= j; j++ {
ret = append(ret, fmt.Sprintf("%s%d", string(i), j-'0'))
}
}
return ret
}
|