引用列值生成SQL语句
 

=CONCATENATE("INSERT INTO 表名 (字段名称, 字段名称, 字段名称) VALUES('",列,"', '",列,"', '",列,"');")


例:

=CONCATENATE("INSERT INTO tb_activity (activity_id, prize_id, card_state, card_no, card_password, card_value, start_time, end_time) VALUES(1, 3, 0, '",C2,"', '",D2,"', '",B2,"' , '2018-03-11', '2021-03-11');")