Documentação do HotXLS

Propriedade PaperSize

Retorna ou define o tamanho do papel. Leitura/gravação LongWord

Sintaxe

property PaperSize: LongWord;

Descrição

PaperSize pode ser uma dessas constantes XlPaperSize
xlPaper11x1711 pol. x 17 pol
xlPaperA4A4 (210 mm x 297 mm)
xlPaperA5A5 (148 mm x 210 mm)
xlPaperB5A5 (148 mm x 210 mm)
xlPaperDsheetFolha tamanho D
xlPaperEnvelope11Envelope #11 (4-1/2 pol. x 10-3/8 pol.)
xlPaperEnvelope14Envelope #14 (5 pol. x 11-1/2 pol.)
xlPaperEnvelopeB4Envelope B4 (250 mm x 353 mm)
xlPaperEnvelopeB6Envelope B6 (176 mm x 125 mm)
xlPaperEnvelopeC4Envelope C4 (229 mm x 324 mm)
xlPaperEnvelopeC6Envelope C6 (114 mm x 162 mm)
xlPaperEnvelopeDLEnvelope DL (110 mm x 220 mm)
xlPaperEnvelopeMonarchEnvelope Monarca (3-7/8 pol. x 7-1/2 pol.)
xlPaperEsheetFolha tamanho E
xlPaperFanfoldLegalGermanFormulário contínuo German Legal (8-1/2 pol. x 13 pol.)
xlPaperFanfoldUSFormulário contínuo US padrão (14-7/8 pol. x 11 pol.)
xlPaperLedgerLedger (17 pol. x 11 pol.)
xlPaperLetterCarta (8-1/2 pol. x 11 pol.)
xlPaperNoteNota (8-1/2 pol. x 11 pol.)
xlPaperStatementDemonstrativo (5-1/2 pol. x 8-1/2 pol.)
xlPaperUserDefinido pelo usuário
xlPaper10x1410 pol. x 14 pol
xlPaperA3A3 (297 mm x 420 mm)
xlPaperA4SmallA4 Pequeno (210 mm x 297 mm)
xlPaperB4B4 (250 mm x 354 mm)
xlPaperCsheetFolha tamanho C
xlPaperEnvelope10Envelope #10 (4-1/8 pol. x 9-1/2 pol.)
xlPaperEnvelope12Envelope #12 (4-1/2 pol. x 11 pol.)
xlPaperEnvelope9Envelope #9 (3-7/8 pol. x 8-7/8 pol.)
xlPaperEnvelopeB5Envelope B5 (176 mm x 250 mm)
xlPaperEnvelopeC3Envelope C3 (324 mm x 458 mm)
xlPaperEnvelopeC5Envelope C5 (162 mm x 229 mm)
xlPaperEnvelopeC65Envelope C65 (114 mm x 229 mm)
xlPaperEnvelopeItalyEnvelope (110 mm x 230 mm)
xlPaperEnvelopePersonalEnvelope (3-5/8 pol. x 6-1/2 pol.)
xlPaperExecutiveExecutivo (7-1/2 pol. x 10-1/2 pol.)
xlPaperFanfoldStdGermanFormulário contínuo German Legal (8-1/2 pol. x 13 pol.)
xlPaperFolioFólio (8-1/2 pol. x 13 pol.)
xlPaperLegalOfício (8-1/2 pol. x 14 pol.)
xlPaperLetterSmallCarta Pequena (8-1/2 pol. x 11 pol.)
xlPaperQuartoQuarto (215 mm x 275 mm)
xlPaperTabloidTabloide (11 pol. x 17 pol.)

Exemplo

Este exemplo define o tamanho do papel como ofício para a Planilha um

Workbook.Sheets[1].PageSetup.PaperSize := xlPaperLegal;