ActiveReports 14 .NET Edition
GrapeCity.ActiveReports.Export.Excel Assembly / GrapeCity.SpreadBuilder.Printing Namespace / PageSetup Class
Members Example

In This Topic
    PageSetup Class
    In This Topic
    Represents page setup information for a worksheet such as margins, paper size, etc.
    Object Model
    PageSetup Class
    Syntax
    'Declaration
     
    Public Class PageSetup 
    public class PageSetup 
    Example
    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 = GrapeCity.SpreadBuilder.Printing.PagePrintOrder.OverThenDown;
    sb.Sheets[0].PageSetup.Orientation = GrapeCity.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;
    With sb.Sheets(0).PageSetup
        .BlackAndWhite = True
        .BottomMargin = 144
        .Draft = True
        .FirstPageNumber = 100
        .FooterMargin = 72
        .HeaderMargin = 72
        .LeftMargin = 108
        .Order = GrapeCity.SpreadBuilder.Printing.PagePrintOrder.OverThenDown
        .Orientation = GrapeCity.SpreadBuilder.Printing.PagePrintOrientation.Landscape
        .PaperSize = Printing.PaperKind.A4
        .PrintNotes = True
        .RightMargin = 108
        .TopMargin = 144
        .Zoom = 200
    End With
    Inheritance Hierarchy

    System.Object
       GrapeCity.SpreadBuilder.Printing.PageSetup

    See Also