The Export Excel action is used in the Kuika platform to export certain datasets in Excel format. Data, usually the result of an SQL query, can be downloaded as an Excel file to provide meaningful reports and analysis to the user. This action is only supported in web applications.
Technical Specifications
Data Export: The selected dataset is exported in Excel format.
SQL Query Results: Tables retrieved with SQL can be directly converted to Excel.
Web Application Compatibility: This action only works in web applications.
Header and Footer Customization: Header and footer information can be added to the Excel file.
Easy Sharing: The created files can be easily shared and reported.
Export Excel Action Implementation Steps
Add Export Excel Action
Log in to Kuika and open your project.
Switch to the UI Design module and select the screen to process.
Create a button (for example, “Export to Excel”).
Select the button, click on the Properties panel on the right side + ADD ACTION menu.
Value (String - mandatory): The data set to export to the Excel file. Usually the result of an SQL query is used.
They are usually defined using data sources such as Action Result, Current, Form Component, Screen Input or Fixed and can be bound via Symbol Picker.
Adding Optional Parameters
Header (String - optional): Title, date or description that can be added to the file.
Footer (String - optional): Information to be added below the file, such as a note, copyright information or date.
All parameters can be defined with the data sources mentioned above.
Usage Scenario: Exporting Data in Excel Format
When a user wants to export a specific data (for example, a sales report or a customer list) through the application, the Export Excel action is activated to download this data in Excel format. Converts the data into 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 will work on from the Apps screen.
Switch to the UI Design module and open the Properties panel on the right side.
Select the button you want to add an action to (for example, the “Export Data to Excel” button).
From the+ ADD ACTION drop-down menu, follow these steps:
Onclick → Export → Export Excel.
Configure Export Excel Parameters
In the window that opens, configure the following fields:
Value: data.tableData → Specify the data to export to the Excel file. This is usually a table retrieved from a SQL query or database within the application.
Configuring Optional Parameters
+ ADD OPTIONAL PARAMETER button to add the required parameters:
Header: “Sales Report - 2025” → Title or text at the top of the Excel file.
Footer: “This report was generated automatically by the system.” → Text or note added at the bottom of an Excel file.
After Action Usage
When this action is executed, the selected data will be exported in Excel format.
The data will be converted to Excel file after adding Header and Footer.
With the Download File action, the user can download the file to their device or use it in another action.
Export Excel Action Advanced Customizations
Dynamic Header and Footer: Dynamically add information such as user's name, date, report number to the header/footer.
Data Formatting: Edit date formats, number rounding or column names to create more readable tables.
Data Compression: You can improve performance by using filtering or summarization methods on large data sets.
Technical Risks and Controls
Data Size: Large data sets can increase the size of the Excel file. Compression methods can be applied.
Invalid Data Structure: Ensure that the dataset used in the Value parameter is a correct and valid table.
Header/Footer Format: Header and Footer texts should be prepared in proper format, special characters should be checked.
Export Excel action allows Kuika users to generate easy, readable and shareable Excel reports via web applications. It provides a powerful reporting infrastructure with dynamic data binding, header/footer customizations and SQL compatibility. With this action, you can speed up your reporting processes, improve user experience and increase efficiency.
