如何使用c＃动态更改工作表对象 [英] how to dynamically change worksheet object using c#

问题描述

Worksheet ws= (Worksheet)wb.Worksheets[1];
Excel.Worksheet ws2 = wb.Sheets.Add(missing, missing, 1, missing)
            as Excel.Worksheet;
ws.get_Range("A1", "K2").Merge(true);
ws.get_Range("A1", "K2").Font.Name = "Times New Roman";
ws.get_Range("A1", "K2").Font.Size = "14";
ws.get_Range("A1", "K2").Font.Bold = true;
ws.get_Range("A1", "K2").FillLeft();
ws.Cells[2, 1] = "Line Chart Summary-BOTTOM";

这里我创建了两个工作表.one是另一个是ws1。

我使用ws作为对象名称。我想使用C＃编码将ws更改为ws1。

here i create two work sheet.one is ws another one is ws1.
above i using ws as object name .i want to change ws to ws1 using C# coding.

ws1.get_Range("A1", "K2").Merge(true);
ws1.get_Range("A1", "K2").Font.Name = "Times New Roman";
ws1.get_Range("A1", "K2").Font.Size = "14";
ws1.get_Range("A1", "K2").Font.Bold = true;
ws1.get_Range("A1", "K2").FillLeft();
ws1.Cells[2, 1] = "Line Chart Summary-BOTTOM";// Like this i want to change.

在Visual Basic 2008的.NET 3.5中使用C＃，我试图设置焦点（或激活）打开的工作簿中的特定工作表。对于一个用户我使用对象ws另一个用户我使用对象ws1所以我想动态更改工作表对象。

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.for one user i use object ws another user i use object ws1 so i want to dynamically change the worksheet object.

推荐答案

这篇关于如何使用c＃动态更改工作表对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！