An administrator wants to export a table generated by a specific SQL query in the application to Excel format. However, this is not a direct download; the data must first be converted to Base64 format and then used in another process (e.g., download, send by email, save to server). The Get Excel Base64 action is used for this conversion.
Adding the Get Excel Base64 Action
- Log in to the Kuika platform.
- Open the project you will be working on from the Apps screen.
- Go to the UI Design module.
- Open the Properties panel on the right side.
- Select the component to which you want to add the action (e.g., the ‘Export to Excel’ button).
- Follow the steps: + ADD ACTION → Onclick → Export → Get Excel Base64.
Configuring the Get Excel Base64 Action Parameters
Fill in the following fields in the action window that opens:
- Value: Specifies the table data to be converted to Excel (usually data obtained from an SQL query).
- Header: ‘Sales Report’ → The header that will be displayed at the top of the Excel file.
- Footer: ‘This document was automatically generated by the system.’ → Explanation to be added to the bottom of the Excel document.
After configuring the settings, click the SAVE button to complete the process.
Post-Action Usage
- After this action is executed, Get Excel Base64 generates an Excel file in Base64 format.
- You can:
- Send this data to the Download File action to allow the user to download it,
- send it as an email using the Send Email action,
- or serve it to different applications.
