更新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.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", EXCELFILENAME);
string query = String.Format("select * from [{0}$]", workbookName);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
DataTable myTable = dataSet.Tables[0];
如何从单元格中读取数据并将其存储在数组/字符串中。我已经读取了工作表,但找不到更好的方法。
这是我的Excel表格的样子:
我应该能够传递列名(例如test_case_1或test_case_2等等),然后读取该特定行的列...
test_case_1
,我应该能够仅读取属于test_case_1
的行..根据您上面的代码..看起来它会读取整个Excel表..是吗? - Nick Kahn