分享
golang xlsx读写
Feng_Sir · · 6360 次点击 · · 开始浏览这是一个创建于 的文章,其中的信息可能已经有所发展或是发生改变。
func TestRequest_LoadFromRemote2(t *testing.T) {
xlsxfile2, err := xlsx.OpenFile("E:/apihub/1数据核查/信息核查数据.xlsx")
if err != nil{
fmt.Println( err)
return
}
for _, sheet := range xlsxfile2.Sheets {
for indexr, row := range sheet.Rows {
if indexr < 2 {
continue
}
//if indexr >= 3{
// break
//}
fmt.Print(fmt.Sprint(indexr)+"姓名:",strings.Trim(row.Cells[1].Value," ")," 身份证号:",strings.Trim(row.Cells[2].Value," "))
request := Request{}
request.IdCode = strings.Trim(row.Cells[2].Value," ")
request.Name = strings.Trim(row.Cells[1].Value," ")
ret, cost, e, remark := request.LoadFromRemote()
fmt.Println(ret, cost, e, remark)
row.AddCell().Value = fmt.Sprint(ret)
fmt.Println()
}
}
err = xlsxfile2.Save("E:/apihub/1数据核查/信息核查数据结果.xlsx")
if err != nil{
log.Println(err)
return
}
fmt.Println("ok")
}
有疑问加站长微信联系(非本文作者)
入群交流(和以上内容无关):加入Go大咖交流群,或添加微信:liuxiaoyan-s 备注:入群;或加QQ群:692541889
关注微信6360 次点击
添加一条新回复
(您需要 后才能回复 没有账号 ?)
- 请尽量让自己的回复能够对别人有帮助
- 支持 Markdown 格式, **粗体**、~~删除线~~、
`单行代码` - 支持 @ 本站用户;支持表情(输入 : 提示),见 Emoji cheat sheet
- 图片支持拖拽、截图粘贴等方式上传
收入到我管理的专栏 新建专栏
func TestRequest_LoadFromRemote2(t *testing.T) {
xlsxfile2, err := xlsx.OpenFile("E:/apihub/1数据核查/信息核查数据.xlsx")
if err != nil{
fmt.Println( err)
return
}
for _, sheet := range xlsxfile2.Sheets {
for indexr, row := range sheet.Rows {
if indexr < 2 {
continue
}
//if indexr >= 3{
// break
//}
fmt.Print(fmt.Sprint(indexr)+"姓名:",strings.Trim(row.Cells[1].Value," ")," 身份证号:",strings.Trim(row.Cells[2].Value," "))
request := Request{}
request.IdCode = strings.Trim(row.Cells[2].Value," ")
request.Name = strings.Trim(row.Cells[1].Value," ")
ret, cost, e, remark := request.LoadFromRemote()
fmt.Println(ret, cost, e, remark)
row.AddCell().Value = fmt.Sprint(ret)
fmt.Println()
}
}
err = xlsxfile2.Save("E:/apihub/1数据核查/信息核查数据结果.xlsx")
if err != nil{
log.Println(err)
return
}
fmt.Println("ok")
}