• Excel导入数据库,兼容Excel2003,2007


            public static System.Data.DataSet ExcelConnection(string filepath, string exName, string tableName, out string errmsg)
            {
                errmsg = "";
                string strCon = "";
                if (exName == ".xls")
                    strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";
                if (exName == ".xlsx")
                    strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=\"Excel 12.0;HDR=YES\"";

                System.Data.OleDb.OleDbConnection ExcelConn = new System.Data.OleDb.OleDbConnection(strCon);
                try
                {
                    ExcelConn.Open();
                    DataTable dt = ExcelConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
                    if (dt == null)
                        return null;
                    string excelSheet = dt.Rows[0]["TABLE_NAME"].ToString();

                    string strCom = string.Format("SELECT * FROM [" + excelSheet + "]");

                    System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, ExcelConn);
                    DataSet ds = new DataSet();
                    myCommand.Fill(ds, tableName);
                    ExcelConn.Close();
                  
                    return ds;
                }
                catch(Exception ex)
                {
                    errmsg = ex.Message;
                    ExcelConn.Close();
                    return null;
                }
            }

  • 相关阅读:
    分布式系统理论基础
    分布式系统理论基础
    RPC框架实现
    分布式服务协调员zookeeper
    LSM Tree存储组织结构介绍
    协程 及 libco 介绍
    回顾2013——新的旅程
    从prototype beandefinition 谈 spring 的关闭流程和 prototype 的特性
    调研 中央空调 地暖 水暖
    物联网安全设计
  • 原文地址:https://www.cnblogs.com/fhuafeng/p/2628566.html
Copyright © 2020-2023  润新知