Problem
ExcelWriter supports the insertion of horizontal and vertical page breaks within a Worksheet using the ExcelApplication class/object. This post covers how to insert page breaks in a worksheet.
Solution
- Worksheet.InsertHorizontalPageBreak – inserts a horizontal page break
- Worksheet.InsertVerticalPageBreak – inserts a vertical page break
C# Example
//--- The following namespace has been imported:
//--- SoftArtisans.OfficeWriter.ExcelWriter
//--- Instantiate ExcelApplication and create a new Workbook
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
Worksheet sheet1 = wb.Worksheets[0];
//--- Insert horizontal page break below cell A15
sheet1.InsertHorizontalPageBreak(sheet1.Cells["A15"]);
//--- Insert vertical page break to the right of cell H1
sheet1.InsertVerticalPageBreak(sheet1.Cells["H1"]);
//--- Save Workbook
xla.Save(wb, Response, "out.xls", false);
Share the post "How to insert page breaks using ExcelWriter"
Follow