"SELECT * FROM [sheet $]"; 有 5个 sheet

Question

public DataSet Xlsdata(string filepath)
    {
       // string strCon = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + filepath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=0;\"";
        string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
        OleDbConnection Conn = new OleDbConnection(strCon);

  这句     string strCom = "SELECT * FROM [Sheet1$]";

有 5个 sheet 1 ，2，3，4，5

怎么办 能连起来写吗

Answer 1

excel不同sqlserver可以执行多语句
读取到dataset里面去，用oledbdataadapter多fill几次，fill前修改sql语句