将excel中的数据转换成insert语句
=CONCATENATE("insert into tbclass(id,className, boardType) values (",A2," , '",B2,"' , '",C2,"');")
| id | className | boardType | |
| 1 | java | 编程 | insert into tbclass(id,className, boardType) values (1 , 'java' , '编程'); |
| 2 | C# | 编程 | insert into tbclass(id,className, boardType) values (2 , 'C#' , '编程'); |
| 3 | C | 编程 | insert into tbclass(id,className, boardType) values (3 , 'C' , '编程'); |
| 4 | 数据库 | 编程 | insert into tbclass(id,className, boardType) values (4 , '数据库' , '编程'); |

浙公网安备 33010602011771号