Generate Excel document in SAP CAP application
source link: https://answers.sap.com/questions/13773540/generate-excel-document-in-sap-cap-application.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Generate Excel document in SAP CAP application
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
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK