PaperSize Property (PageSetup)

Visual Basic
C#

'Declaration
 
Public Property PaperSize As PaperKind

public PaperKind PaperSize {get; set;}

Property Value

Printing.PaperKind enumeration. The default value is Letter.

C#

sb.Sheets(0).PageSetup.BlackAndWhite = true;
sb.Sheets(0).PageSetup.BottomMargin = 144;
sb.Sheets(0).PageSetup.Draft = true;
sb.Sheets(0).PageSetup.FirstPageNumber = 100;
sb.Sheets(0).PageSetup.FooterMargin = 72;
sb.Sheets(0).PageSetup.HeaderMargin = 72;
sb.Sheets(0).PageSetup.LeftMargin = 108;
sb.Sheets(0).PageSetup.Order = DataDynamics.SpreadBuilder.Printing.PagePrintOrder.OverThenDown;
sb.Sheets(0).PageSetup.Orientation = DataDynamics.SpreadBuilder.Printing.PagePrintOrientation.Landscape;
sb.Sheets(0).PageSetup.PaperSize = Printing.PaperKind.A4;
sb.Sheets(0).PageSetup.PrintNotes = true;
sb.Sheets(0).PageSetup.RightMargin = 108;
sb.Sheets(0).PageSetup.TopMargin = 144;
sb.Sheets(0).PageSetup.Zoom = 200;

Visual Basic

With sb.Sheets(0).PageSetup
    .BlackAndWhite = True
    .BottomMargin = 144
    .Draft = True
    .FirstPageNumber = 100
    .FooterMargin = 72
    .HeaderMargin = 72
    .LeftMargin = 108
    .Order = DataDynamics.SpreadBuilder.Printing.PagePrintOrder.OverThenDown
    .Orientation = DataDynamics.SpreadBuilder.Printing.PagePrintOrientation.Landscape
    .PaperSize = Printing.PaperKind.A4
    .PrintNotes = True
    .RightMargin = 108
    .TopMargin = 144
    .Zoom = 200
End With

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

PageSetup Class
PageSetup Members