c# 导入

最新推荐文章于 2023-07-26 13:30:12 发布

weixin_30572613

最新推荐文章于 2023-07-26 13:30:12 发布

阅读量88

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/dengjie/archive/2011/10/26/2225271.html

选择按钮得到路径

    openFileDialog1.FileName = "选择您要输入得文件";
                openFileDialog1.Filter = "Excel2007|*.xlsx|Excel2003|*.xls";
                openFileDialog1.Title = "请选择指定格式的服务器列表文件";
                openFileDialog1.InitialDirectory = System.AppDomain.CurrentDomain.BaseDirectory.ToString();
                openFileDialog1.RestoreDirectory = true;

                if (openFileDialog1.ShowDialog() == DialogResult.OK)
                {
                    this.textBox1.Text = openFileDialog1.FileName;
                }

确定按钮导入到页面。

try
            {
                string strConn = "";
                string filePath = openFileDialog1.FileName;

string str = filePath.Substring(filePath.LastIndexOf(".") + 1, filePath.Length - filePath.LastIndexOf(".") - 1);

                if (str == "xlsx")
                {
                    strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filePath + ";" + "Extended Properties=Excel 12.0;";
                }
                else
                {
                    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source='" + filePath + "';" + "Extended Properties=Excel 8.0;";
                }
                OleDbConnection oleConn = new OleDbConnection(strConn);
                oleConn.Open();
                try
                {
                    OleDbCommand cmd = oleConn.CreateCommand();
                    cmd.CommandText = string.Format(" select * from [{0}$]", "Sheet1");//[sheetName$]要如此格式
                    ///OleDbDataReader odr = cmd.ExecuteReader();
                    OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
                    DataSet ds = new DataSet();
                    adapter.Fill(ds);