How to set page layout break on worksheet using EPPlus

c# export-to-excel epplus
thatstevedude picture thatstevedude · Feb 2, 2016 · Viewed 10k times · Source

Is there a way to set specify where to break the page using EEPlus? I have the following code that sets the printer properties but haven't found a way to set a break point on a certain column.

// Set printer settings
ws.PrinterSettings.PaperSize = ePaperSize.Tabloid;
ws.PrinterSettings.Orientation = eOrientation.Landscape;
ws.PrinterSettings.FitToPage = true;
ws.PrinterSettings.FitToHeight = 1;
ws.PrinterSettings.FooterMargin = .05M;
ws.PrinterSettings.TopMargin = .05M;
ws.PrinterSettings.LeftMargin = .05M;
ws.PrinterSettings.RightMargin = .05M;

Edit (this helped solve my problem)

ws.Column(30).PageBreak = true;
ws.PrinterSettings.PaperSize = ePaperSize.A3;
ws.PrinterSettings.Orientation = eOrientation.Landscape;
ws.PrinterSettings.Scale = 75;

Answer

Ernie S picture Ernie S · Feb 2, 2016

Just need to get reference to the Row and/or Column objects:

ws.Row(20).PageBreak = true;
ws.Column(2).PageBreak = true;

But keep in mind that FitToPage might suppress these.

Related questions

Formatting a column with EPPLUS Excel Library

I wrote a C# program to create an excel spreadsheet. The sheet has multiple columns. I want to format ONE of the columns. aFile = new FileInfo(excelDocName); // excelDocName is a string ExcelPackage pck = new ExcelPackage(aFile); var ws = pck.Workbook.…

Read More
Download Excel file via AJAX MVC

I have a large(ish) form in MVC. I need to be able to generate an excel file containing data from a subset of that form. The tricky bit is that this shouldn't affect the rest of the form and …

Read More
Format an Excel column (or cell) as Text in C#?

I am losing the leading zeros when I copy values from a datatable to an Excel sheet. That's because probably Excel treats the values as a number instead of text. I am copying the values like so: myWorksheet.Cells[i + 2, …

Read More