Kuika's Import Excel Base64 action allows you to import an Excel Base64 value into your default database as a data table. Each worksheet is converted into a table and the sheet names are used as table names. In this tutorial, you will learn how to import an Excel Base64 value into a database as a table using the Import Excel Base64 action.

Import Excel Base64 action is only supported by web applications.

This training content consists of the following topics:

Adding an Import Excel Base64 action.
Configuring Import Excel Base64 parameters.

Add Import Excel Base64 Action

After logging into the Kuika platform, open the project you will work on from the “Apps” screen.
While in the “UI Design” module, open the “Properties” panel on the right side.

3. Select “Initial Action> Export> Import Excel Base64” from the “+ ADD ACTION” drop-down menu.

4. Configure the “Excel Base64” field from the drop-down menu. This field is the field where the Base64 value of the Excel file to be imported is written.

Configure Import Excel Base64 Parameters

Click on the “ + ADD OPTIONAL PARAMETER” (1) drop-down menu.

Configure the following parameters from the drop-down menu:
- Table name: Allows you to define the table name where the data you import will be written.
- Primary key name: Defines the name of the primary key of the data you are importing.some text
  - If a row has a key value (Primary Key) and this field is empty in Excel, the data will be inserted as a new record.
  - If the key value exists and the field in Excel is full, the existing record is updated.
  - If the key value is not entered, the platform automatically accepts it as “Id”.
Then click on the “SAVE” (2) button to complete the configuration process.