'DeclarationPublic 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 _ )
'DeclarationPublic 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 _ )
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" ); } }
.NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.
.NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.