XL.Sheet.GetPaper
-----------------

Returns the paper size.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [3.5](newinversion35.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Sheet.GetPaper"; BookRef; SheetIndex ) 

**MBS**( **"XL.Sheet.GetPaper";** /\* Returns the paper size. \*/  
**$BookRef**; /\* The reference number for the workbook.e.g. $ref \*/   
**$SheetIndex**) /\* The index of the sheet. This number ranges from 0 to [XL.Book.SheetCount](XLBookSheetCount.md)-1.e.g. 0 \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference number for the workbook. | $ref |
| SheetIndex | The index of the sheet. This number ranges from 0 to [XL.Book.SheetCount](XLBookSheetCount.md)-1. | 0 |

### Result

Returns paper format.

### Description

Returns the paper size.  
| Paper | Value | Description |
|---|---|---|
| PAPER\_DEFAULT | 0 | Default paper size |
| PAPER\_LETTER | 1 | US Letter 8 1/2 x 11 in |
| PAPER\_LETTERSMALL | 2 | US Letter Small 8 1/2 x 11 in |
| PAPER\_TABLOID | 3 | US Tabloid 11 x 17 in |
| PAPER\_LEDGER | 4 | US Ledger 17 x 11 in |
| PAPER\_LEGAL | 5 | US Legal 8 1/2 x 14 in |
| PAPER\_STATEMENT | 6 | US Statement 5 1/2 x 8 1/2 in |
| PAPER\_EXECUTIVE | 7 | US Executive 7 1/4 x 10 1/2 in |
| PAPER\_A3 | 8 | A3 297 x 420 mm |
| PAPER\_A4 | 9 | A4 210 x 297 mm |
| PAPER\_A4SMALL | 10 | A4 Small 210 x 297 mm |
| PAPER\_A5 | 11 | A5 148 x 210 mm |
| PAPER\_B4 | 12 | B4 (JIS) 250 x 354 |
| PAPER\_B5 | 13 | B5 (JIS) 182 x 257 mm |
| PAPER\_FOLIO | 14 | Folio 8 1/2 x 13 in |
| PAPER\_QUATRO | 15 | Quarto 215 x 275 mm |
| PAPER\_10x14 | 16 | 10 x 14 in |
| PAPER\_10x17 | 17 | 11 x 17 in |
| PAPER\_NOTE | 18 | US Note 8 1/2 x 11 in |
| PAPER\_ENVELOPE\_9 | 19 | US Envelope #9 3 7/8 x 8 7/8 |
| PAPER\_ENVELOPE\_10 | 20 | US Envelope #10 4 1/8 x 9 1/2 |
| PAPER\_ENVELOPE\_11 | 21 | US Envelope #11 4 1/2 x 10 3/8 |
| PAPER\_ENVELOPE\_12 | 22 | US Envelope #12 4 3/4 x 11 |
| PAPER\_ENVELOPE\_14 | 23 | US Envelope #14 5 x 11 1/2 |
| PAPER\_C\_SIZE | 24 | C size sheet |
| PAPER\_D\_SIZE | 25 | D size sheet |
| PAPER\_E\_SIZE | 26 | E size sheet |
| PAPER\_ENVELOPE\_DL | 27 | Envelope DL 110 x 220mm |
| PAPER\_ENVELOPE\_C5 | 28 | Envelope C5 162 x 229 mm |
| PAPER\_ENVELOPE\_C3 | 29 | Envelope C3 324 x 458 mm |
| PAPER\_ENVELOPE\_C4 | 30 | Envelope C4 229 x 324 mm |
| PAPER\_ENVELOPE\_C6 | 31 | Envelope C6 114 x 162 mm |
| PAPER\_ENVELOPE\_C65 | 32 | Envelope C65 114 x 229 mm |
| PAPER\_ENVELOPE\_B4 | 33 | Envelope B4 250 x 353 mm |
| PAPER\_ENVELOPE\_B5 | 34 | Envelope B5 176 x 250 mm |
| PAPER\_ENVELOPE\_B6 | 35 | Envelope B6 176 x 125 mm |
| PAPER\_ENVELOPE | 36 | Envelope 110 x 230 mm |
| PAPER\_ENVELOPE\_MONARCH | 37 | US Envelope Monarch 3.875 x 7.5 in |
| PAPER\_US\_ENVELOPE | 38 | US Envelope 3 5/8 x 6 1/2 in |
| PAPER\_FANFOLD | 39 | US Std Fanfold 14 7/8 x 11 in |
| PAPER\_GERMAN\_STD\_FANFOLD | 40 | German Std Fanfold 8 1/2 x 12 in |
| PAPER\_GERMAN\_LEGAL\_FANFOLD | 41 | German Legal Fanfold 8 1/2 x 13 in |

### See also

- [XL.Book.SheetCount](XLBookSheetCount.md)
- [XL.Sheet.GetHeader](XLSheetGetHeader.md)
- [XL.Sheet.GetName](XLSheetGetName.md)
- [XL.Sheet.GetPicture](XLSheetGetPicture.md)
- [XL.Sheet.GetProtect](XLSheetGetProtect.md)
- [XL.Sheet.GetVCenter](XLSheetGetVCenter.md)
- [XL.Sheet.SetFooter](XLSheetSetFooter.md)
- [XL.Sheet.SetHeader](XLSheetSetHeader.md)
- [XL.Sheet.SetName](XLSheetSetName.md)
- [XL.Sheet.SetPaper](XLSheetSetPaper.md)

This function checks for a license.

Created 18th August 2014 , last changed 6th October 2015

  
[XL.Sheet.GetNamedRange](XLSheetGetNamedRange.md) - [XL.Sheet.GetPicture](XLSheetGetPicture.md)

[HTML Version](XLSheetGetPaper.shtml)