SetAll Method

Visual Basic
C#

'Declaration
 
Public Sub SetAll( _
   ByVal left As Single, _
   ByVal right As Single, _
   ByVal top As Single, _
   ByVal bottom As Single, _
   ByVal header As Single, _
   ByVal footer As Single _
)

'Usage
 
Dim instance As Margins
Dim left As Single
Dim right As Single
Dim top As Single
Dim bottom As Single
Dim header As Single
Dim footer As Single
 
instance.SetAll(left, right, top, bottom, header, footer)

public void SetAll( 
   float left,
   float right,
   float top,
   float bottom,
   float header,
   float footer
)

Parameters

left: The Left Margin's value.
right: The Right Margin's value.
top: The Top Margin's value.
bottom: The Bottom Margin's value.
header: The Header's value.
footer: The Footer's value.

C#

public static void PageMarginsAndPageBreaks()
{
  using( var workbook = Workbook.Create( PageLayoutSample.PageLayoutSampleOutputDirectory + @"PageMarginsAndBreaks.xlsx" ))
    {
      // Gets the first worksheet; a workbook always contains at least 1 worksheet.
      var worksheet = workbook.Worksheets[0];
	  
      // Adds a title.
      worksheet.Cells["B1"].Value = "Page Margins and Breaks";
      worksheet.Cells["B1"].Style.Font = new Font() {Bold = true, Size = 15.5d};
	  
      // Sets all margins using custom values
      worksheet.PageLayout.Margins.SetAll( 0.7f, 0.7f, 0.5f, 0.5f, 0.4f, 0.4f );

      // Saves workbook to disk.
      workbook.Save();
      Console.WriteLine( "/tCreated:PageMarginsAndBreaks.xlsx/n" );
    }
}

Target Platforms: Windows 11, Windows 10, 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

Margins Class
Margins Members