NativeExcel for .Net Developer's Reference

IPageSetup.FitToPagesTall Property

Gets or sets the number of pages tall the worksheet will be scaled to when it's printed.

[Visual Basic]

Property Value

If this property is 0, the worksheet will be scaled according to the FitToPagesWide property. If the FitToPages property is false, the FitToPagesTall property is ignored and the Zoom property control how the worksheet is scaled.


This example causes to print worksheet one exactly one page tall and wide.

book.Worksheets[1].PageSetup.FitToPagesTall = 1;
book.Worksheets[1].PageSetup.FitToPagesWide = 1;
book.Worksheets(1).PageSetup.FitToPagesTall = 1
book.Worksheets(1).PageSetup.FitToPagesWide = 1
book->Worksheets->Item[1]->PageSetup->FitToPagesTall = 1;
book->Worksheets->Item[1]->PageSetup->FitToPagesWide = 1;

See Also

IPageSetup Interface | NativeExcel Namespace | FitToPagesWide Property | Zoom Property