The Import Excel Base64 action allows you to import an Excel Base64 value as a table into your default database. 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.

The Import Excel Base64 action is only supported in web applications.

This training content consists of the following topics:

Add Import Excel Base64 action
Configure Import Excel Base64 parameters

Add Import 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 → Import Excel Base64.

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

‍

Configure Import Excel Base64 Parameters

+ ADD OPTIONAL PARAMETER drop-down menu.

Configure the following parameters from the drop-down menu:
- Table Name: Used to specify the table name where the data you import will be written.
- Primary Key Name: Used to specify the name of the primary key of the data you import.
Complete the configuration process by clicking the SAVE button.

By following these steps, you can successfully configure the Import Excel Base64 action on the Kuika platform.

‍