Author: Jonas Bilinkevicius

How to add a page break to an Excel worksheet

Answer:

If WS is your worksheet:

1   { ... }
2   Excel.ActiveWindow.View := xlPageBreakPreview;
3   WS.HPageBreaks.Add(WS.Cells.Item[78, 1]);
4   { ... }