Greetings.
I'm working on a SAP CAP (NodeJS) + Fiori Elements + SAP HANA application on SAP BTP.
The application handles various CDS tables and views internally.
Now I have a requirement in which I must generate an excel document with the data from the views/tables, and that the user can download it by clicking a button on the UI.
In principle, the report is an excel workbook where each sheet shows the data from some view/data table (with some formatting in certain cases). The data in this report does not correspond only to the data displayed by the app itself (it is a larger data set).
The question here is that I don't know where to start, what libraries or Node modules to use?, what support do I have in CAP CDS for this?, etc.
Any help, suggestion, example, link or material that can guide me to start would be of great help.
Thanks in advance