I'm wanting to use FlexCel for a report. What I'm struggling with is the new pages on printing to PDF. In essence I have a template sheet that takes up a bit less than a page. I want a PDF that shows a page for each of the data objects (name, dates etc). When I do a Report.Run(), it takes the data, reads the template, outputs a new XLSX file with the results, pretty much as I would expect. But to make the PDF, I have to load it again, and that doesn't seem to know about the additional pages and the KeepRows_1_data range is only on the first page. The PDF then ends up with new pages at random points as I presume it doesn't know the keep together now that was in the original XLSX file.
I figured I'd have the Run() make the PDF, or return the XlsFile object to pass to the PDF print, but it appears to be inaccessible directly.
I can't see an example that shows how this would happen, but maybe I've missed it.
I also note that Excel has an "insert page break" menu item, which in its printing it takes account of. I figured that might help, but it isn't replicated in the report run, so obviously isn't known.
Is this going to be possible, or should I give up and use something more appropriate? Thank you for your assistance.