利用Microsoft.ACE.OLEDB读取Excel源代码

        /// <summary>
        /// 获得Excel的数据到DataSet 贾世义
        /// </summary>
        /// <param name="fileName">Excel完整文件名</param>
        /// <param name="isFirstTitle">首行是否为标题行</param>
        /// <returns></returns>
        public static DataSet GetDataFromExcel(string fileName, bool isFirstTitle)
        {
            DataSet ds = null;
               string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + fileName + ";Extended Properties='Excel "
                    + (fileName.EndsWith("xls", StringComparison.CurrentCultureIgnoreCase) ? "8" : "12") + ".0;HDR=" + (isFirstTitle ? "Yes" : "No") + "'";
                using (OleDbConnection conn = new OleDbConnection(strConn))
                {
                    conn.Open();
                    //返回Excel的架构，包括各个sheet表的名称,类型，创建时间和修改时间等 
                    DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
                    ds = new DataSet();
                    //包含excel中表名的字符串数组
                    for (int k = 0; k < dtSheetName.Rows.Count; k++)
                    {
                        string strTableName = dtSheetName.Rows[k]["TABLE_NAME"].ToString();
                        string str = "select * from [" + strTableName + "]";
                        OleDbDataAdapter da = new OleDbDataAdapter(str, conn);
                        da.Fill(ds, strTableName.Replace("$", "").ToLower());
                        da.Dispose();
                    }
                    if (!isFirstTitle)
                    {
                        foreach (DataTable dt in ds.Tables)
                        {
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                dt.Columns[j].ColumnName = j.ToString();
                            }
                        }
                    }
                    conn.Close();
                    conn.Dispose();
                }
            return ds;
        }

欢迎访问：http://121.18.78.216 适易查询分析、工作流、内容管理及项目管理演示平台