C# 获取Excel中数据

来源：互联网发布：防盗窗面积算法编辑：程序博客网时间：2024/05/19 16:50
        using System.Data.OleDb;        public static DataTable GetDataTableFromExcel(string SourceFilePath)        {            string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +                                        "Data Source=" + SourceFilePath + ";" +                                        "Extended Properties=Excel 8.0;";            using (OleDbConnection cn = new OleDbConnection(ConnectionString))            {                cn.Open();                DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);                if (dbSchema == null || dbSchema.Rows.Count < 1)                {                    throw new Exception("Error: Could not determine the name of the first worksheet.");                }                //修改此处可遍历Excel表格中各个工作表                string WorkSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString();                OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + WorkSheetName + "]", cn);                DataTable dt = new DataTable(WorkSheetName);                da.Fill(dt);                return dt;            }        }