xls 拼接字符串 生成sql

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

原文地址:https://www.cnblogs.com/heiniao/p/5996531.html