Kuika's Export Excel action is used to export a specific data set in Excel format. It enables the download of tabular data obtained as a result of a SELECT query in your application. It provides a flexible solution for sharing and analyzing data in Excel format as part of your existing workflow. In this tutorial, you will learn how to export your data as an Excel file using the Export Excel action.

Export Excel action is only supported in web applications.

This training content consists of the following topics:

Adding an Export Excel action,
Configure Export Excel parameters.

Add Export Excel Action

After logging into the Kuika platform, open the project you will work on from the “Apps” screen.
While in the “UI Design” module, open the “Properties” panel on the right side.

Select “Initial Actions → Export → Export Excel” from the “+ADD ACTION” drop-down menu.

In the “Value” field you can specify the data to be exported to an Excel file.

Configure Export Excel Parameters

Click on the drop-down menu “+ ADD OPTIONAL PARAMETER” (1).

Configure the following parameter from the drop-down menu:

Header: Used for texts such as title, description, date, company information, etc. to be added at the top of the Excel file.
Footer: Used for notes, page number, copyright information or other descriptive text to be added at the bottom of the Excel file.