C# read Excel file using OleDb , and get the exception Could not find installabl

[极品老土豆]

                ExcelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Scource='C:\Users\xxglding\Desktop\数据接收模板.xlsx';Extended Properties='Excel 12.0'";
                    DataTable table;
                    using (OleDbConnection OleDbConn = new OleDbConnection(ExcelConnectionString))
                    {
                        Console.Write("Coming");
                        string CommandText = "select * from [sheet1$]";
                        OleDbCommand OleDbComm = new OleDbCommand(CommandText, OleDbConn);
                        OleDbDataAdapter OleDbAdapter = new OleDbDataAdapter(OleDbComm);
                        DataSet ds = new DataSet();
                        OleDbConn.Open();
                        OleDbAdapter.Fill(ds, "Shot");
                        table = ds.Tables["Shot"];
                    }

关于 ExcelConnectionString 的标点符号,各种形式都试过,没有用,求解

[极品老土豆]

我知道了阿斯顿飞阿斯顿飞阿萨德

[秋的红果实]

//OleDbCommand OleDbComm = new OleDbCommand(CommandText, OleDbConn); 去掉这句 OleDbDataAdapter OleDbAdapter = new OleDbDataAdapter(CommandText, OleDbConn); DataSet ds = new DataSet(); OleDbConn.Open(); OleDbAdapter.Fill(ds, "Sheet1"); table = ds.Tables[0];

[江南小鱼]

引用 1 楼 DBAXMMDS 的回复:

我知道了阿斯顿飞阿斯顿飞阿萨德

多动手调试，要学会自己找问题嘛，撸主