Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

XL.Sheet.GetPaper

Returns the paper size.

Component Version macOS Windows Linux Server iOS SDK
XL 3.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.GetPaper"; bookRef; sheetIndex )   More

Parameters

Parameter Description Example
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0

Result

Returns paper format.

Description

Returns the paper size.
PaperValueDescription
PAPER_DEFAULT0Default paper size
PAPER_LETTER1US Letter 8 1/2 x 11 in
PAPER_LETTERSMALL2US Letter Small 8 1/2 x 11 in
PAPER_TABLOID3US Tabloid 11 x 17 in
PAPER_LEDGER4US Ledger 17 x 11 in
PAPER_LEGAL5US Legal 8 1/2 x 14 in
PAPER_STATEMENT6US Statement 5 1/2 x 8 1/2 in
PAPER_EXECUTIVE7US Executive 7 1/4 x 10 1/2 in
PAPER_A38A3 297 x 420 mm
PAPER_A49A4 210 x 297 mm
PAPER_A4SMALL10A4 Small 210 x 297 mm
PAPER_A511A5 148 x 210 mm
PAPER_B412B4 (JIS) 250 x 354
PAPER_B513B5 (JIS) 182 x 257 mm
PAPER_FOLIO14Folio 8 1/2 x 13 in
PAPER_QUATRO15Quarto 215 x 275 mm
PAPER_10x141610 x 14 in
PAPER_10x171711 x 17 in
PAPER_NOTE18US Note 8 1/2 x 11 in
PAPER_ENVELOPE_919US Envelope #9 3 7/8 x 8 7/8
PAPER_ENVELOPE_1020US Envelope #10 4 1/8 x 9 1/2
PAPER_ENVELOPE_1121US Envelope #11 4 1/2 x 10 3/8
PAPER_ENVELOPE_1222US Envelope #12 4 3/4 x 11
PAPER_ENVELOPE_1423US Envelope #14 5 x 11 1/2
PAPER_C_SIZE24C size sheet
PAPER_D_SIZE25D size sheet
PAPER_E_SIZE26E size sheet
PAPER_ENVELOPE_DL27Envelope DL 110 x 220mm
PAPER_ENVELOPE_C528Envelope C5 162 x 229 mm
PAPER_ENVELOPE_C329Envelope C3 324 x 458 mm
PAPER_ENVELOPE_C430Envelope C4 229 x 324 mm
PAPER_ENVELOPE_C631Envelope C6 114 x 162 mm
PAPER_ENVELOPE_C6532Envelope C65 114 x 229 mm
PAPER_ENVELOPE_B433Envelope B4 250 x 353 mm
PAPER_ENVELOPE_B534Envelope B5 176 x 250 mm
PAPER_ENVELOPE_B635Envelope B6 176 x 125 mm
PAPER_ENVELOPE36Envelope 110 x 230 mm
PAPER_ENVELOPE_MONARCH37US Envelope Monarch 3.875 x 7.5 in
PAPER_US_ENVELOPE38US Envelope 3 5/8 x 6 1/2 in
PAPER_FANFOLD39US Std Fanfold 14 7/8 x 11 in
PAPER_GERMAN_STD_FANFOLD40German Std Fanfold 8 1/2 x 12 in
PAPER_GERMAN_LEGAL_FANFOLD41German Legal Fanfold 8 1/2 x 13 in

See also

This function checks for a license.

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


XL.Sheet.GetNamedRange - XL.Sheet.GetPicture