Thanks for your feedback Andrey.
In fact I already tried this approach but it is close to impossible to have the footer looking like the rest of the document (a footer is not a grid of cells). In the end it looks weird.
Then I looked at
XlsxFormatter class, paging seemed not too difficult to implement myself. After all paging only requires managing special bands (page data, header, footer). And by extension header & footer special bands. Then you have the generally accepted pattern for report generators.
But I found no way to make YARG use an override of this class.
I finally managed to get what I wanted, by implemeting paging directly in a service, managing page header, page footer and footer, and relying heavily on
reporting.putEmptyRowIfNoDataSelected = false in order to fool YARG. But that was clearly not trivial.
It’s puzzling that YARG manages paging with/through HTML, with/through Jasper, but not for XLS (and for DOC if I saw right, did not test).
Without paging & footer, it’s ok to produce ad hoc lists of books, but when figures comes into play or if you want an official business document, it is getting difficult.