C# Excel Doubt

[rejijo]

Excel WorkBook has 2 worksheets in it. I want to set the VIEW >> Zoo
(i.e Magnification ) of the 1st Excel Worksheet to 70% and the 2n
Worksheet to 80% thru the code (C#).

I have tried using "objExcelWorkbook.Windows[1].Zoom = 80 ;" , but thi
will set the zoom percentage of only one worksheet.

I also tried setting the zoom on each Worksheet as follows :
objSheet1.PageSetup.Zoom = 70;
objSheet2.PageSetup.Zoom = 80;
But the above code will set the PageSetup Zoom (ie PrintPreview) bu
not the View >> Zoom.

Any Ideas, how to set the View - Zoom of both the Sheets

 

[rejijo]

ok , I got the solution :

for(int intSheetCtr =1; intSheetCtr <
objExcelWorkbook.Worksheets.Count ;intSheetCtr++) {
objExcelSheet
(Excel.Worksheet)objExcelWorkbook.Worksheets.get_Item(intSheetCtr);
objExcelSheet.Activate();
if(intSheetCtr == 1)
objExcelWorkbook.Windows[1].Zoom = 70;
else if(intSheetCtr == 2)
objExcelWorkbook.Windows[1].Zoom = 80;