Usage Scenario: Transferring an Excel File to Application Tables

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

• Element: ‘Import from Excel’ button
• Trigger: OnClick
• Action: Export → Import Excel Base64
• Parameters
  
  • Excel Base64: uploadFile.base64
  • Table Name: ‘UserList’
  • Primary Key Name: ‘userId’

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.