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

  1. Log in to the Kuika platform.
  2. Open the project you will work on from the Apps screen.
  1. Switch to the UI Design module and open the Properties panel on the right side.
  2. Select the button you want to add an action to (for example, the “Export Data to Excel” button).
  3. From the+ ADD ACTION drop-down menu, follow these steps:
  4. 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.