C# 读取EXCEL问题,怎么读取某一个单元格的内容 (OLEDB方式)
public void getConnect(string path)
{
DataTable excelTable;
//创建一个数据链接
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();
string strCom = "select * from [" + "UDC$" + "]";
//打开数据链接,得到一个数据集
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
//创建一个 DataSet对象
DataSet myDataSet = new DataSet();
//得到自己的DataSet对象
myCommand.Fill(myDataSet, "[UDC$]");
//关闭此数据链接
myConn.Close();
//---------------
//string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = d:\\sample.xls;Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";
dataGrid.DataMember = "[UDC$]";
dataGrid.DataSource = myDataSet;
}
可以再datagrid控件里看到excel的内容了,但不知道怎么获取某个特定单元格的数据