Microsoft Excel或者Google Sheet合并列出来新的列

Microsoft Excel或者Google Sheet合并列出来新的列
试用与根据Excel中的数据拼出可以用的sql等
=CONCATENATE(A2," ",B2," ",C2," ","insert into")
把A2,B2,C2中的文字拼凑在一起 然后在和insert into拼起来

=CONCATENATE(" INSERT INTO AR_SELL(TYPE_CODE, YEAR_MONTH, P_INDEX, PROVINCE, CITY, COUNTRY, SHOP_CODE, SHOP_NAME, BRAND_NAME, SELL_COUNT, SELL_MONEY) VALUES (","'",A2,"','",B2,"','",C2,"','",D2,"','",E2,"','",F2,"','",H2,"','",G2,"','",I2,"','",J2,"','",K2,"');")

然后把sql列保存到文件a.sql，使用sqlplus执行

sqlplus user/pass@server
--SET AUTO[COMMIT] { OFF | ON | IMM[EDIATE] | n }
--每100次操作提交一次
set auto 100;
--执行a.sql文件中的sql语句
@"D:\a.sql"