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

In This Topic
    HeaderMargin Property
    In This Topic
    Returns or sets the distance in points from the top of the page to the header.
    Syntax
    'Declaration
     
    Public Property HeaderMargin As Double
    public double HeaderMargin {get; set;}

    Property Value

    Short. The default value is 36.
    Remarks
    The value MUST be greater than or equal to 0 and less than 3528.
    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
    See Also