C#导入EXCEL数据

最新推荐文章于 2024-08-26 15:35:39 发布

weixin_34258782

最新推荐文章于 2024-08-26 15:35:39 发布

阅读量80

点赞数

原文链接：http://www.cnblogs.com/wangzhenghua/p/3622679.html

版权

  public static void InputUserFromExcel(string filePath)
        {
            string FileExName = filePath.Substring(filePath.LastIndexOf(".") + 1);
            string mystring = "Provider = Microsoft.ACE.OLEDB.12.0 ; Data Source ='" + filePath + "';Extended Properties ='Excel 12.0;HDR=YES;IMEX=1'";
            if (FileExName == "xls")
            {
                mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source ='" + filePath + "';Extended Properties=Excel 8.0";
            }
            OleDbConnection cnnxls = new OleDbConnection(mystring);
            cnnxls.Open();
            OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [pos_260$]", cnnxls);
            DataSet ZLDs = new DataSet();
            myDa.Fill(ZLDs);
            Console.Write(ZLDs.Tables[0].Rows.Count);
            Console.Read();

        }
    }

转载于:https://www.cnblogs.com/wangzhenghua/p/3622679.html