C# 读取Excel文件数据

C# 读取Excel模板数据

		/// <summary>
        /// 读取Excel文件数据
        /// </summary>
        /// <param name="filePath"></param>
        /// <returns></returns>
        /// <exception cref="Exception"></exception>
        public DataSet ReadFile(string filePath)
        {
            string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=Excel 12.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            DataSet ds = new DataSet();
            try
            {
                conn.Open();
                //获取列表信息  
                DataTable SheetNames = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });//获取列表名称  
                string[] TableNames = new string[SheetNames.Rows.Count];
                for (int k = 0; k < SheetNames.Rows.Count; ++k)
                {
                    TableNames[k] = SheetNames.Rows[SheetNames.Rows.Count - k - 1]["TABLE_NAME"].ToString();//遍历  
                    Console.WriteLine(TableNames[k]);
                }
                string strExcel = @"select * from [{0}]";
                strExcel = string.Format(strExcel, TableNames);
                OleDbDataAdapter da = new OleDbDataAdapter(strExcel, strConn);              
                da.Fill(ds);
            }
            catch (Exception ex)
            {
                throw new Exception("读取Excel失败：" + ex.Message);
            }
            finally
            {
                conn.Close();
            }
            return ds;
        }