Page breaks?

[thedude61636]

is there a way to add a page break?
cannot find it in the docs

[salvois]

Hi @thedude61636 ,
at present there is no feature for page breaks.
I'm keeping this issue open as a feature request. Please feel free to create a pull request if interested.

[thedude61636]

Alright, any hint on where can I start or how can I find out the object to write in the excel file?

[dgosbell]

@thedude61636 - I would suggest the following:

1. create a simple file in excel with a couple of lines of text that are easy to search for eg:

abc123
def456

2. Save this as something like no-breaks.xlsx
3. then put a page break between the two lines and save the file with a different name eg page-breaks.xlsx
4. the rename these two xlsx files to .zip and unzip them into separate folders
5. then use a comparison tool like Winmerge to compare the files in the two folders

This should allow you to see what changes Excel made in the internal xml in order to insert a page break