Excel Zooming

[Administrator]

Hello,
I am creating an Excel template from scratch. One of the client's requirment is to open the worksheet at a specified zoom level. The default Zoom is 100% and the user can change to whatever they want, but if I want to open the worksheet at 50% zoom level, how do I do it.

Thank you for your assistance

[Giancarlo Aguilera]

worksheet.Zoom = 50;

>Hello,
I am creating an Excel template from scratch. One of the client's requirment is to open the worksheet at a specified zoom level. The default Zoom is 100% and the user can change to whatever they want, but if I want to open the worksheet at 50% zoom level, how do I do it.

Thank you for your assistance

[Melba Winshia]

Hi,

You can use Zoom property to set the zoom factor of a worksheet. Please refer the following code snippet which illustrates the above:

[C#]

//Setting the zoom factor
sheet.Zoom = 50;

[VB.NET]

'Setting the zoom factor
sheet.Zoom = 50

Here is the sample for your reference:

Zoom.zip

Please take a look and let me know if you have any other questions.

Best Regards,
Melba