Get Excel Base64

Adding Get Excel Base64 Action to Project

1. Open your project in Kuika.
2. Open the relevant screen in the UI Design module.
3. Select the component to add an action to (for example a button).

4. Select a trigger (OnClick, Initial Actions, etc.) from the + ADD ACTION menu in the right panel.
5. Add the Export > Get Excel Base64 action.

Configure Get Excel Base64 Parameters

• Value (String, required):
  
  • Specifies the data set to convert to Excel (for example: data.tableData).
  • It is usually defined using data sources such as Action Result, Current, Form Component, Screen Input or Fixed and can be linked via Symbol Picker.
• Header (String, optional):
  
  • It is usually defined using data sources such as Action Result, Current, Form Component, Screen Input or Fixed and can be linked via Symbol Picker.
• Footer (String, optional):
  
  • Description or information to be displayed at the bottom (for example: “This document was auto-generated by the system.”).
  • It is usually defined using data sources such as Action Result, Current, Form Component, Screen Input or Fixed and can be linked via Symbol Picker.

Completing the Registration Process

After configuring your parameters, click the SAVE button to save your changes. This step ensures that the Get Excel Base64 action is successfully added.

An administrator wants to export the table resulting from a specific SQL query in the application in Excel format. However, this operation is not a direct download; the data will first be converted to Base64 format and then used in another operation (e.g. downloading, e-mailing, saving to the server). The Get Excel Base64 action is activated for this conversion.

Adding the Get Excel Base64 Action

1. Log in to the Kuika platform.
2. Open the project you will work on from the Apps screen.

3. Switch to the UI Design module.
4. Open the Properties panel on the right side.
5. Select the component you want to add an action to (for example the “Export to Excel” button).
6. Follow the steps + ADD ACTION → Onclick → Export → Get Excel Base64.

Configure Get Excel Base64 Action Parameters

In the action window that opens, fill in the following fields:

• Value: “data.tableData” → specifies the table data to be converted to Excel (usually the data obtained from a SQL query).
• Header: “Sales Report” → the title to be displayed at the beginning of the Excel file.
• Footer: “This document was auto-generated by the system.” → Description to be added at the bottom of the Excel document.

After adjusting the settings, click the SAVE button to complete the action.

After Action Usage

• After this action runs, Get Excel Base64 will produce an Excel file in Base64 format.
• This data:
  
  • It can send it to theDownload File action and download it to the user,
  • It can send it as an e-mail withSend Email action,
  • API to the server.

• Dynamic Header & Footer: Make headers and footers dynamic with information such as date, user name, report number, etc.
• Data Formatting: Create more readable reports by applying custom formatting for date and numeric values.
• Data Compression: Filter or split large data sets before converting them to Base64 format.
• Integration Potential: The resulting Base64 data:
  
  • Download it with the Download File action,
  • Add to email sending with Send Email action,
  • Send to other systems via API.

Technical Risks and Controls

• Data Size: Large files may bloat in Base64 format. Compression should be applied if necessary.
• Invalid Table: Value parameter must contain valid data format. Missing data can cause problems.
• Formatting Issues: Header and Footer text should be structured to be short, clean and free of special characters.

The Get Excel Base64 action allows you to convert your data to Excel format and get it encoded. In this way, operations such as downloading, sharing, e-mailing or transferring data to the server can be performed in a secure and controlled manner. It is a powerful action especially in large reporting and integration scenarios.