How to: Zoom In and Out of a Worksheet


You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these examples in production code.

This example demonstrates how to zoom a worksheet view (Worksheet.ActiveView). To do this, set the WorksheetView.Zoom property to an integer value that specifies the required zoom factor for a worksheet view.


To specify how a worksheet should be scaled when it is printed, use the WorksheetPrintOptions.Scale property of the object accessed via Worksheet.PrintOptions. Refer to the How to: Specify Print Settings document for details on how to specify print options for a worksheet.

// Zoom in the worksheet view. 
workbook.Worksheets[0].ActiveView.Zoom = 150;

The image below shows the result (the workbook is opened in Microsoft® Excel®).