The Get Excel Base64 action is used to convert an Excel file to Base64 format. It allows you to get the data of Excel files in an encoding format and make it available for further processing. After running a SQL SELECT query, you can get the resulting table in Base64 format by converting it to an Excel file. As part of your existing workflow, you can convert Excel files to Base64 format and easily access this data within your application.
The Get Excel Base64 action is only supported in web applications.
Add Get Excel Base64 Action
Log in to the Kuika platform and 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.
Click on the + ADD ACTION drop-down menu.
Select Initial Actions → Export → Get Excel Base64.
Configure the following fields from the drop-down menu:
Value: Represents the content of the table selected for conversion to Excel file.
Header: Determines the header text that will appear at the top of the Excel file.
Footer: Defines the additional information or footer text at the bottom of the Excel file.
By following these steps, you can successfully configure the Get Excel Base64 action on the Kuika platform.
