XlsIO excel document paper size in inches or pixels

[Sychev Stepan]

Good day!

We have used sheet.PageSetup.PaperSize() method to got the PaperSize type. How can I get the paper size (width and height) in pixels or inches?

[Dilli Babu Nandha Gopal]

Hi Syschev

In XlsIO, the paper size of worksheet is maintained by ExcelPaperSize enumeration. There is no function to obtain the pixel or inches value of paper size for a worksheet. You can write a custom function by getting the size information from MS Excel as shown below.

Screen shot:

Regards,

Dilli babu