Xceed Workbooks for .NET v2.0 Documentation
SetPreset Method
Example 


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace > Margins Class : SetPreset Method
The MarginPreset that will be used to set the Worksheet's Margins.
Sets which MarginPreset will be used.
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

Reference

Margins Class
Margins Members