jsreport can render very complex pdf documents. It can render table of contents, bookmarks or truly dynamic headers.
Templating engine like handlebars can be used to dynamically assemble the dashboard tables.
Literally every javacsript library can be used to display dynamic charts. No limitations.
This means implementing an invoice or an e-ticket can be done by every beginner developer just with basic css and html knowledge.
Prepare xlsx template using destkop excel application. Upload it to the jsreport and use simple html and css to do the rest.
jsreport takes care of transformating your html tables into the final excel report.