All geek questions in one place

How to set page layout markup on a sheet using EPPlus

Is there any way to establish where to split the page using EEPlus? I have the following code that sets the printer properties, but did not find a way to set a breakpoint in a specific 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;
+5
source share
1 answer

You just need to get a link to the Row and / or Column objects:

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

But keep in mind that FitToPage can overwhelm them.

+6
source

Source: https://habr.com/ru/post/1242124/

More articles:


All Articles