1.4.7. Excel Import

Imports data from an Excel file and saves it to the database.

• How-To

1. Create a button for uploading Excel files and register a Click Service for it.
2. Create an Excel Import Action for the registered Service, and select the selectTemplate Action parameter. Choose the template to use for import from the configured Excel Templates.
   (*Refer to Chapter 4. Data Modeling 🡪 3. Utility 🡪 3.4. Excel Template, 3.5. Excel Work for Template creation configuration*)
   
3. In the Optional section, set the Parameter Key to templateId.
4. When Excel Import is executed, add a Confirm Message Box to allow the user to confirm before proceeding. Set the Key value for the Message Box Action arbitrarily, and set the Parameter Key to the fixed values content, title, Yes, and No.