UPDATE 2
string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", EXCELFILENAME);
string testCaseName = "test_case_2";
string query = String.Format("SELECT * from [{0}$] WHERE columns={1}", workbookName, testCaseName);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet); //<<ERROR
DataTable myTable = dataSet.Tables[0];
string connectionString = String.For