'UsageDim instance As PageLayout Dim column As Integer instance.RemovePageBreakColumn(column)
'UsageDim instance As PageLayout Dim column As Integer instance.RemovePageBreakColumn(column)
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}; // Inserts page breaks using columns as a reference point for the insertion. worksheet.PageLayout.InsertPageBreakColumn(11); worksheet.Pagelayout.InsertPageBreakColumn(50); // Removes a specific page break. worksheet.PageLayout.RemovePageBreakColumn(11); // 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.