Skip to Content
3
Dec 12, 2022 at 01:44 AM

Generate Excel document in SAP CAP application

647 Views Last edit Dec 12, 2022 at 01:45 AM 2 rev

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