Get Excel Base64

Get Excel Base64

The Get Excel Base64 action is used to convert specific table data on the Kuika platform into an Excel file and obtain this file in Base64 format. It plays an important role in the export process of data obtained with SQL SELECT queries. This action is only valid for web applications.

Technical Features

  • Excel Conversion: Converts data from SQL or table sources into an Excel file.
  • Base64 Encoding: Converts the created Excel file into Base64 format.
  • Header and Footer Customisation: Dynamic information can be added to the top and bottom sections of the Excel file.
  • Web Application Support: The action only works in web applications.
Get Excel Base64 Action Implementation Steps

Adding the Get Excel Base64 Action to the Project

  1. Open your project in Kuika.
  2. Open the relevant screen in the UI Design module.
  3. Select the element to which the action will be added (e.g. a button).
  1. Select a trigger (OnClick, Initial Actions, etc.) from the + ADD ACTION menu in the right panel.
  2. Add the Export > Get Excel Base64 action.

Configuring Get Excel Base64 Parameters

  • Value (String, required):
    • Specifies the data set to be converted to Excel.
    • It is usually defined using data sources such as Action Result, Current, Form Component, Screen Input or Fixed, and can be linked via the Symbol Picker.
  • Header (String, optional):
    • Header text to be added to the top of the file (e.g. ‘Sales Report’).
    • It is usually defined using data sources such as Action Result, Current, Form Component, Screen Input or Fixed and can be linked via the Symbol Picker.
  • Footer (String, optional):
    • Explanation or information to be displayed at the bottom (e.g. ‘This document was automatically 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 the 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.

Usage Scenario: Downloading Table Data in Excel Format

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

  1. Log in to the Kuika platform.
  2. Open the project you will be working on from the Apps screen.
  1. Go to the UI Design module.
  2. Open the Properties panel on the right side.
  3. Select the component to which you want to add the action (e.g., the ‘Export to Excel’ button).
  4. 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.
Get Excel Base64 Action Advanced Customizations
  • Dynamic Header & Footer: Make headers and descriptions dynamic with information such as date, user name, and report number.
  • Data Formatting: Create more readable reports by applying custom formatting to dates and numerical values.
  • Data Compression: Filter or split large data sets before converting them to Base64 format.
  • Integration Potential: Download the generated Base64 data:
    • Download File action to download,
    • Send Email action to add to an email,
    • Send to other systems via API.

Technical Risks and Controls

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

The Get Excel Base64 action converts your data into Excel format and retrieves it in an encoded form. This enables secure and controlled processes such as downloading, sharing, emailing, or transferring data to a server. It is a powerful action, especially for large reports and integration scenarios.

Other Related Content

No items found.

Glossary

No items found.

Alt Başlıklar