读取Excel中的数据

/// <summary>
        /// 转换Excel文件转换为DataSet
        /// </summary>
        /// <returns>DataSet</returns>
        private DataSet GetExcelData()
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + this.textBox1.Text.Trim() +"; Extended Properties=Excel 8.0; ";
            DataSet myDataSet = new DataSet();
            try
            {
                OleDbConnection conn = new OleDbConnection(strConn);
                //Sheet1$为Excel的工作表名称
                OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$] ", strConn);
                myCommand.Fill(myDataSet);
            }
            catch (Exception exp)
            {
                MessageBox.Show("导入Excel失败！！！"+exp.Message);
            }
            return myDataSet;
        }

转载于:https://www.cnblogs.com/snlfq2000/archive/2010/09/06/1819061.html