本文介绍了使用C#来选择在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工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!