How to set zoom level for excel sheet using epplus library?

Question

This seems like a very simple thing, but I cannot find the epplus property that allows me to set the zoom level of the sheet. I tried the following property:

workSheet.PrinterSettings.Scale

But he did not set the zoom level of the excel sheet. We are waiting for offers ...

Answer 1

You need to access the property through a worksheet Viewas follows:

worksheet.View.ZoomScale = 250;

In this case, the above value will be set at 250%.