C# 从Excel表中导入数据函数到DataSet

/// <summary>         /// 读取Excel表格数据方法三,返回数据集DataSet         /// </summary>         /// <param name="str">所要打开的文件地址</param>         /// <returns></returns>         private DataSet GetExcelDataSet1(string strExcelFilePath)         {             try             {                 ///建立连接,读取表格中的数据                 string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + strExcelFilePath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1';";///建立连接,地址为str传递的地址                 OleDbConnection myConn = new OleDbConnection(strCon);                 string strCom = " SELECT * FROM [Sheet1$A:Q]";///SQL操作语句,就是说:取得所有数据从Sheet1                 myConn.Open();                 OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);                 DataSet myDataSet = new DataSet();///建立新的数据集myDataSet                 myCommand.Fill(myDataSet, "[Sheet1$]");///填充数据集                 myConn.Close();                 int columnNum = myDataSet.Tables[0].Columns.Count;///读取列数并赋值给columnNum                 int rowNum = myDataSet.Tables[0].Rows.Count;///读取行数并赋值给rowNum                 int resultRowNum = columnNum - 1;                 Console.WriteLine("列数"+columnNum.ToString());                 Console.WriteLine("行数" + rowNum.ToString());                 Console.WriteLine("有效记录数" + resultRowNum.ToString());                                ///读取结果行数(实际上就是去掉第一列编号列的列数,我的程序中将结果显示横置了)                                                                  return myDataSet;             }             catch (Exception ex)             {                 MessageBox.Show("发生错误" + ex.Message);                 return null;             }         }