Groovy 使用EasyExcel操作Excel

示例一:
读取Excel,打印拼接的Sql

import com.alibaba.excel.EasyExcel

class Obj {
    Integer num;
    String name;
}

def readerBuilder = EasyExcel.read(new File(/C:\Users\kiss\Documents\2023-02\demo.xlsx/),
        Obj, null)
List<Obj> list = readerBuilder.sheet(0).doReadSync()
list.each {
    def sql = /insert into sup_home_response_detail(id, company_name, show, order_num) values(uuid(), \
'$it.name', 0, $it.num);/
    println sql

posted @ 2023-03-02 08:50  豆苗稀  阅读(307)  评论(0编辑  收藏  举报