C#与EXCEL

1.配置EXCEL链接

        public OleDbConnection getExcelConn(string filepath)
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=2'";
            OleDbConnection OleConn = new OleDbConnection(strConn);
            return OleConn;
        }

 2.操作EXCEL

            String filepath = path + "xls\\" + Program.username + "_" + damlname + ".xls";
            OleDbConnection conn = getExcelConn(filepath);
            conn.Open();
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = conn;
            cmd.CommandText = "INSERT INTO [" + damlname + "$] (dh,qzh,ndu,jgname,bgqx,hh,jh,ptotal) values('" + nowdh + "','" + qzh + "','" +
                ndu + "','" + jgname + "','" + qx + "','" + hh + "','" + jh + "','" + ptotal + "')";
            cmd.ExecuteNonQuery();
            conn.Close();

 3.查询EXCEL

        public string getjgdm(string jgname)
        {
            string jgdmpath = path + "xls\\jgdmdzb.xls";
            OleDbConnection OleConn = getExcelConn(jgdmpath);
            OleConn.Open();
            String sql = "SELECT 机构代码 FROM  [机构代码对照表$] where 机构名称='" + jgname + "'";//可是更改Sheet名称,比如sheet2,等等
            OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
            DataSet OleDsExcle = new DataSet();
            OleDaExcel.Fill(OleDsExcle, "机构代码对照表");
            OleConn.Close();
            System.Data.DataTable table = OleDsExcle.Tables[0];
            string jgdm = table.Rows[0][0].ToString();
            return jgdm;
        }

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值