1、批量插入
=CONCATENATE("insert into table_name(column_name1, column_name2, column_name3, column_name4, column_name5) values('"&A1&"','"&B1&"','"&C1&"','"&D1&"','"&E1&"');")
=CONCATENATE("insert into table_name(column_name1, column_name2, column_name3, column_name4, column_name5) values('"&A1&"','"&B1&"','"&C1&"','"&D1&"','"&E1&"');")