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";
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";
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.