C#中访问Excel的两种方法

最新推荐文章于 2024-07-11 00:41:48 发布

PlusPlus1

最新推荐文章于 2024-07-11 00:41:48 发布

阅读量5.8k

点赞数 1

分类专栏： Dotnet 文章标签： excel c# dataset properties string sql

本文链接：https://blog.csdn.net/whucyl/article/details/7856310

版权

Dotnet 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

方法一：使用 Microsoft.Office.Interop.Excell类库

示例代码如下：

 public void openExcel(string file)
        {
            excel = new ExcelLib.ApplicationClass();
            excel.Application.Workbooks.Add(true);
            excel.Cells[1, 1] = "First Row First Column";
            excel.Cells[1, 2] = "First Row Second Column";
            excel.Cells[2, 1] = "Second Row First Column";
            excel.Cells[2, 2] = 200;
            DateTime time = DateTime.Now;
            excel.Cells[3,1] = time;
            excel.Visible = true;
             
        }

方法二：采用数据库连接的方式

示例代码如下：

  public void openExecl(string filepath)
        {
        	 string type = filepath.Substring(filepath.LastIndexOf(".") + 1);
            string connStr;
            if (type.Equals("xls", StringComparison.CurrentCultureIgnoreCase))
            {
                connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
                    + filepath + ";Extended Properties=Excel 8.0";
            }
            else
            {
                connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
                    + filepath +
                    ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";";
            }
            OleDbConnection conn = new OleDbConnection(connStr);
            conn.Open();
            string sql = "select * from [Sheet1$A1:L93]";
            IDataAdapter dadp = new OleDbDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            dadp.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
        	
        }