C# 导入Excel到DataSet中

class Import
    {

        /// <summary>
        /// 导入Excel到DataSet中
        /// </summary>
        /// <param name="strFileSourse">文件的路径和文件全名，含扩展名</param>
        /// <returns></returns>
        public DataSet ExcelToDataSet(string strFileSourse)
        {
            DataSet ds = new DataSet();
            //Excel数据源（兼容03/10）
            string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFileSourse + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\"";
            //连接
            OleDbConnection conn = new OleDbConnection(strConn);
            try
            {
                conn.Open();
                //获取Excel中所有的sheet
                DataTable dtSheet = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

                //把Excel中所有的sheet数据读到一个Table中
                for (int i = 0; i < dtSheet.Rows.Count; i++)
                {
                    string strSheetName = dtSheet.Rows[i]["TABLE_NAME"].ToString();
                    OleDbDataAdapter OleDa = new OleDbDataAdapter("select * from [" + strSheetName + "]", conn);
                    OleDa.Fill(ds, "TableName");
                    conn.Close();
                }
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
            finally
            {
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }

            return ds;
        }


    }

转载于:https://www.cnblogs.com/anglee/p/4173779.html