C#Winformd读取excel文件数据转化为DataTable

来源:互联网 发布:linux激活网卡 编辑:程序博客网 时间:2024/06/05 22:31
 public DataTable ExcelToDT()        {            DataTable dt = new DataTable();            string filePath = Application.StartupPath + @"\Skills_TreeView\Skills.xls";            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties=Excel 8.0;";            using ( OleDbConnection conn = new OleDbConnection(strConn))            {                conn.Open();                string strExcel = "select * from [sheet1$]";                OleDbDataAdapter myCommand = new OleDbDataAdapter(strExcel, strConn);                myCommand.Fill(dt);            }                       return dt;        }



0 0