I have searched diligently for logic on inserting a page break on an export to excel script depending upon the first column value. Column 1 of my view that gets exports contains 2 values, either P1 or P2. I want to insert a page break on the excel spreadsheet export between the P1 and P2.
The export logic I have works fine, I just can't find the script logic to force the pagebreak upon the export.
Please help !!
Thank you !