使用C＃来选择在Excel工作表 [英] using c# to select a worksheet in excel

问题描述

使用.NET 3.5的C＃和Visual Studio 2008，我想将焦点设置（或激活），在打开的工作簿的特定工作表：

下面是一些属性：

 公共Excel.Application xlApp {获取;集;}
公共Excel.Workbook xlWorkBook {获得;组; }
公共Excel.Worksheet xlWorkSheet {获得;组; }
公共Excel.Range范围{获得;组; }
 

和这里是如何我想选择一个特定的工作表：

<$p$p><$c$c>(xlWorkSheet)Application.ActiveWorkbook.Sheets[FormControls.WorksheetFocus]).Select(Type.Missing);

和我也尝试过这种方式：

 （（Excel.Worksheet）this.Application.ActiveWorkbook.Sheets [1]）选择（）;
 

我是什么做错了吗？我该如何选择一个工作簿中特定工作表使用C＃？

---

在哪里的定义解释：

 命名空间EmailSalesVolumeSolution
{
    一流的工作薄
    {
        公共字符串MasterFileName {获得;组; }
        公共字符串[] DistinctEmails {获得;组; }
        公共Excel.Application xlApp {获取;集;}
        公共Excel.Workbook xlWorkBook {获得;组; }
        公共Excel.Worksheet xlWorkSheet {获得;组; }
        公共Excel.Range范围{获得;组; }
 

和一切都在同一类和命名空间

下面是它是如何initiliazed：

 私人无效OpenWorkBook（）
{
    字符串str;
    INT RCNT = 0;
    INT CCNT = 0;


    xlApp =新Excel.ApplicationClass（）;
    xlWorkBook = xlApp.Workbooks.Open（MasterFileName，0，真的，5，，，真实，
        Microsoft.Office.Interop.Excel.XlPlatform.xlWindows，
        \ t的，假的，假的，0，真正的，1，0）;
    xlWorkSheet =（Excel.Worksheet）xlWorkBook.Worksheets.get_Item（FormControls.WorksheetEmails）;
 

解决方案

下面是我做的和它的作品！

  Excel.Worksheet xlWorkSheetFocus =（Excel.Worksheet）xlWorkBook.Worksheets.get_Item（2）;
xlWorkSheetFocus.Activate（）;
 

Using C# in .NET 3.5 with Visual Studio 2008, I am trying to set focus (or activate) a specific worksheet in an open workbook:

Here are some properties:

public Excel.Application xlApp {get;set;}
public Excel.Workbook xlWorkBook { get; set; }
public Excel.Worksheet xlWorkSheet { get; set; }
public Excel.Range range { get; set; }        

And here is how I am trying to select a specific worksheet:

(xlWorkSheet)Application.ActiveWorkbook.Sheets[FormControls.WorksheetFocus]).Select(Type.Missing);

And I have also tried this way:

((Excel.Worksheet)this.Application.ActiveWorkbook.Sheets[1]).Select();

What am I doing wrong? How do I select a specific worksheet in a workbook using C#?

---

explanation of where the definitions are:

namespace EmailSalesVolumeSolution
{
    class WorkBook
    {
        public string MasterFileName { get; set; }
        public string[] DistinctEmails { get; set; }
        public Excel.Application xlApp {get;set;}
        public Excel.Workbook xlWorkBook { get; set; }
        public Excel.Worksheet xlWorkSheet { get; set; }
        public Excel.Range range { get; set; }    

and everything is in the same class and namespace

here is how it is initiliazed:

private void OpenWorkBook()
{
    string str;
    int rCnt = 0;
    int cCnt = 0;


    xlApp = new Excel.ApplicationClass();
    xlWorkBook = xlApp.Workbooks.Open(MasterFileName, 0, true, 5, "", "", true,
        Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,
        "\t", false, false, 0, true, 1, 0);
    xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(FormControls.WorksheetEmails);

解决方案

Here is what I did and it works!

Excel.Worksheet xlWorkSheetFocus = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2);
xlWorkSheetFocus.Activate();

这篇关于使用C＃来选择在Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！