xls 拼接字符串 生成sql

=CONCATENATE("UPDATE  PRPDAGENT set bank = '",E2,"' ,account = '",D2,"' ,accountname='",C2,"' where agentcode = '",B2,"';")

posted on 2016-10-25 14:17  黑鸟卫  阅读(238)  评论(0编辑  收藏  举报