c#操作excel的方法

1、新建项目，添加按钮，功能是读取excel

DataTable dt = new DataTable();

 dt = ReadExcel("D:\\搜狗高速下载\\新建文件夹\\resdandwrite\\111.xlsx", "表格");

目录和excel的表格名称

2、读取excel的方法

 DataSet ds = new DataSet();

            string strConn = "Provider=Microsoft.Ace.OleDb.12.0;Data Source=" + filePath + ";Extended Properties='Excel 12.0;HDR=NO;IMEX=1';";

            try

            {

                OleDbConnection conn = new OleDbConnection(strConn);

                string sql = "select * from [" + SheetName + "$]";

                conn.Open();

                OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, strConn);

                myCommand.Fill(ds, SheetName + "$]");

                DataTable dt = ds.Tables[0];

                conn.Close();

            }

            catch (Exception ex)

            {

                return null;

            }

SheetName就是表格名称

3、插入数据

string sql = "Insert Into [" + SheetName + "$](A,B,C) Values(" + t1.Text +" ," +t2.Text+"," + t3.Text+")";

4、更新数据

  string sql = "UPDATE  [" + SheetName + "$] set A=" + dd.Rows[i][0].ToString() + " ,B=" + dd.Rows[i][1].ToString() + ",C=" + dd.Rows[i][2].ToString() + " where 序号=" + (i + 1);