Table of Contents

XlsFile.InsertHPageBreak Method

Inserts a Horizontal Page Break at the specified row. If there is one already, it will do nothing. If the number of pagebreaks is bigger than the maximum Excel can admit, it will add it anyway, but you might get an exception when saving the file as xls. Exporting as images or PDF will use those additional page breaks. To control what to do when there are too many page breaks, see ExcelFile.ErrorActions

Syntax

Namespace: FlexCel.XlsAdapter

public override void InsertHPageBreak(Int32 row, Boolean aGoesAfter)

Parameters

<-> Parameter Type Description
row Int32 Row where to insert the page break. All row numbers are 1-based, and the breaks occur after the row.
Note that row can be 0, and this would mean a page break before row 1. (which Excel will ignore)
aGoesAfter Boolean This is used by FlexCelReport to add page breaks that behave as if they affected the next row, not the row at the top.

See also