Get Paper Width and Height of Page Setup of Worksheet

Possible Usage Scenarios

Sometimes, you need to know the width and height of the paper size as set in the page setup of a worksheet. Please use the PageSetup.paper_width and PageSetup.paper_height properties for this purpose.

Get Paper Width and Height of Page Setup of Worksheet

The following sample code demonstrates the usage of PageSetup.paper_width and PageSetup.paper_height properties. It first changes the paper size to A2 and obtains the width and height of the paper; then it changes the size to A3, A4, and Letter, retrieving the dimensions for each size respectively.

Sample Code

Console Output

Here is the console output of the above sample code.

PaperA2: 16.54x23.39
PaperA3: 11.69x16.54
PaperA4: 8.27x11.69
PaperLetter: 8.5x11