excel 表生成insert语句。

excel 生成insert 语句   =CONCATENATE("insert into TBGAMEVIPUSER (USERID,PTID,SNDAID,USERNAME,TOTALAMOUNT) values (",A1,",'",B1,"',",C1,",'",D1,"',",E1,");")

转载于:https://blog.51cto.com/xuepengpeng/1656356