Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Margins Class / SetPreset Method
The MarginPreset that will be used to set the Worksheet's Margins.
Example


In This Topic
    SetPreset Method
    In This Topic
    Sets the MarginPreset.
    Syntax
    'Declaration
     
    
    Public Sub SetPreset( _
       ByVal preset As MarginPreset _
    ) 
    'Usage
     
    
    Dim instance As Margins
    Dim preset As MarginPreset
     
    instance.SetPreset(preset)
    public void SetPreset( 
       MarginPreset preset
    )

    Parameters

    preset
    The MarginPreset that will be used to set the Worksheet's Margins.
    Remarks
    The default MarginPreset is Normal.
    Example
    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 margins using preset values
          worksheet.PageLayout.Margins.SetPreset( MarginPreset.Wide );
    
          // Saves workbook to disk.
          workbook.Save();
          Console.WriteLine( "/tCreated:PageMarginsAndBreaks.xlsx/n" );
        }
    }
    Requirements

    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

    See Also