代码人生的小狗窝

一行行枯燥的代码,却描绘出人生的点点滴滴

您现在的位置是:首页>_C#

c# 中实现 选中 excel 的sheet 的有关问题

发布时间:2019-11-21浏览(1635)

    c# 中实现 选中 excel 的sheet 的问题
    private void ggexcelconn(string gangGuSheet)
      {
      OleDbConnection myConn = null;
      DataSet thisDataSet = null;
      Excel.Application myExcel = null;
      Excel.Workbooks myWorkbooks = null;
      Excel._Workbook myWorkbook = null;
      Excel._Worksheet myWorksheet = null;

      try
      {
      myExcel = new Excel.Application();
      myExcel.UserControl = true;
      myWorkbooks = myExcel.Workbooks;
      myWorkbook = myWorkbooks.Open(@"D:\localserver\filename", Missing.Value, Missing.Value,
      Missing.Value, Missing.Value, Missing.Value, Missing.Value,
      Missing.Value, Missing.Value, Missing.Value, Missing.Value,
      Missing.Value, Missing.Value, Missing.Value, Missing.Value);
      myWorksheet = (Excel._Worksheet)myWorkbook.Worksheets[gangGuSheet];
      myExcel.Cells[1, 1] = "日期";
      myExcel.Application.DisplayAlerts = false;
      myExcel.Visible = true;
      myWorkbook.Save();
      }
      catch (Exception ex)
      {

      }
      finally
      {
      if (myExcel != null)
      {
      myExcel.Quit();
      }
      }


    gangGuSheet 作为 sheet 名传进来 为什么我每次修改的值 都是第一页的值 这个excel表有两个 sheet 


    ------解决方案--------------------
    遍历WorkSheet,用名字去找 

    http://www.cnblogs.com/lixx/archive/2008/05/05/1183881.html
    也许这个可以给你帮助