将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 , '数据库' , '编程'); |