When a user wants to export specific data (e.g., a sales report or customer list) from the application, the Export Excel action is triggered to download the data in Excel format. It converts the data to an Excel file and downloads it to the user's device.
Adding the Export Excel Action
- Log in to the Kuika platform.
- Open the project you want to work on from the Apps screen.
- UI Design module and open the Properties panel on the right side.
- Select the button you want to add the action to (for example, the ‘Export Data To Excel’ button).
- + ADD ACTION from the drop-down menu and follow these steps:
- Onclick → Export → Export Excel.
Configuring Export Excel Parameters
In the window that opens, configure the following fields:
- Value: → Specify the data to be exported to the Excel file. This is usually a table taken from an SQL query or the database within the application.
Configuring Optional Parameters
Click the + ADD OPTIONAL PARAMETER button to add the necessary parameters:
- Header: ‘Sales Report - 2025’ → The title or text that will appear at the top of the Excel file.
- Footer: ‘This report was automatically generated by the system.’ → The text or note added to the bottom of the Excel file.
Post-Action Usage
- When this action is executed, the selected data will be exported in Excel format.
- The data is converted to an Excel file after the Header and Footer additions.
- The user can download the file to their device or use it in another process with the Download File action.
