SAP Design Studio - Exporting Data

We have a crosstab in SAP Design Studio Editor and we want to export the data from a Crosstab to Microsoft Excel. Add a button from the basic components to the Editor as shown in the following screenshot.

Add Button

Under Display, add Text – Export to Excel.

Export to Excel

Go to Event and add a script as shown in the following screenshot.

Script Editor

Script to export to Excel


Script to Export

Now execute the application using the arrow mark at the top. Once it is run, click on Export to Excel.


Analysis Application

Open Click

Click on Open or Save to open the excel sheet or to save the sheet to your system.

Excel Sheet