ASP.NET導入Excel

最新推荐文章于 2020-07-03 13:56:06 发布

Gerry_

最新推荐文章于 2020-07-03 13:56:06 发布

阅读量405

点赞数

分类专栏： asp.net 文章标签： asp.net導入excel文件

本文链接：https://blog.csdn.net/zrh1121/article/details/47396081

版权

asp.net 专栏收录该内容

25 篇文章 1 订阅

订阅专栏

  public DataSet ExcelToDS(string Path)
        {
            try
            {
                string strConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + Path + ";Extended Properties='Excel 12.0'";
                OleDbConnection conn = new OleDbConnection(strConn);
                conn.Open();
                string strExcel = "";
                OleDbDataAdapter myCommand = null;
                DataSet ds = null;


                try
                {
                    strExcel = "select * from [工作表1$]";
                    myCommand = new OleDbDataAdapter(strExcel, strConn);
                    ds = new DataSet();
                    myCommand.Fill(ds);
                }
                catch
                {
                    strExcel = "select * from [Sheet1$]";
                    myCommand = new OleDbDataAdapter(strExcel, strConn);
                    ds = new DataSet();
                    myCommand.Fill(ds);


                }
                return ds;
            }
            catch(Exception ex)
            {
                pm.ShowMSG(ex.Message);
                return new DataSet();
            }
          }

調用：

  string ppath = FileUpload1.PostedFile.FileName;
        if (File.Exists(ppath))
        {
            string FileExt = Path.GetExtension(ppath);

            string[] FileExt_set = { ".xls", ".xlsx" };
            if (FileExt != FileExt_set[0] && FileExt != FileExt_set[1])
            {
               pm.ShowMSG("選擇的文件不是Excel文件,請重新選擇.");
            }
            else
            {
                DataSet ds = ExcelToDS(ppath);
                GridView1.DataSource = ds.Tables[0].DefaultView;
                GridView1.DataBind();
            }