Import Excel Base64 enables the transfer of an Excel file in Base64 format to the system and the creation of these data as database tables. Each worksheet in the Excel file is imported as a separate table. The sheet names are used as the names of the tables to be created.
Technical Specifications
Add the Import Excel Base64 Action
Parameter Definitions
Required Parameters
Optional Parameters
An administrator wants to transfer an Excel file containing a user list prepared outside the system to the application database. This file is sent to the system in Base64 format and each page is converted into a table.
Configuration
With this configuration, the data in the Excel file from the external system is converted into a table that can be used within the application.
Technical Risks and Controls
The Import Excel Base64 action automates data import processes, enabling files received from users to be used directly in the Kuika-based system. It is an ideal solution for quickly integrating structures such as lists, inventories, and reports from external systems into the application. It provides significant convenience in table creation, data recording, and integration processes.