网上都没有详细的彻底解决方法
本来出现的错误
表名:string sr="sheet1";
"select * from "+"["+sr+"]";
条件:string so="客户=‘学生’"
“select * from [sheet$] WHERE ' ”+so+“' ”(注意单双引号)
终于找到方法了,当用select * from 表名 where 条件:
//string sql_select = " SELECT * FROM '"+she+"'";//语句不完整,WHRER可以用这种方式
//string sql_select = " SELECT * FROM " + "[pos_sport$]" ;//这样可以,"pos_sports$就不可以"
string sql_select = " SELECT * FROM "+"[" + she + "]";//正确
//string sql_select = " SELECT * FROM [pos_sport$]" ;