excel表转化sql语句

id  name  .........等等

1   小明   .........等等

转化sql语句:

=CONCATENATE("INSERT INTO game_class ('id', name, vendor, game_type, game_class, menu_level1, menu_level2, Background_name, Background_type)
VALUES
 (' "&A1&" ',' "&B1&" ',' "&C1&" ',' "&D1&" ',' "&E1&" ',' "&F1&" ',' "&G1&" ',' "&H1&" ',' "&I1&" ');")
代码中的game_class
#要转化的excel表名,根据自己的表名来写
原文地址:https://www.cnblogs.com/lfl17718347843/p/12462270.html