Page Break Count

Aug 16, 2011 at 10:32 PM
Edited Aug 16, 2011 at 10:33 PM

Hi

 

Is there a way to count the page breaks per sheet? I have an index page that will show page numbers. I have had a look at RowBreaks but, that's not what I need.

Thanks!

Coordinator
Aug 17, 2011 at 5:10 PM

Excel handles the "soft page breaks" (where you don't specify where to set the breaks) in memory so these are not accessible through the OOXML file.

Only "hard page breaks" (the ones you set manually, i.e. RowBreaks) are available to ClosedXML.

To get the soft page breaks you'd have to automate Excel (thus defeating the purpose of this library).