Excel Work

Once you define the template in the previous steps of the Excel Template, you configure how the data will be processed during upload and map the data from the file to the Tables and Columns registered in CALS Studio.

• How to Create

1. Select the Utility > Excel Work menu in the Object Explorer.

2. Click on the New button in the Excel Sheet Work List to register a new Excel Work.

   

3. Define the name, and in the Sheet Name field, select the Sheet registered in the Template File Sheet List of the Excel Template for registration. You can choose one of the following operation methods: Insert, Update, or Delete, and select the Table where you want to process the data as the Target Table.

   

4. In the Excel Cell Work List, you define the properties of the Excel Sheet's columns. You can set attributes such as Required, the Table and Column in CALS to which it maps (Target Column), etc. You can choose the value Fixed in the Work Cell Type to set it as a fixed value. Config allows you to define arbitrary parameters to determine values based on parameters. For example, you can pass on data retrieved from Components on the screen where data is uploaded or values such as sequence numbers generated at the time of upload. You can also use Transform to define new values by combining values from the worksheet. The purpose of the Excel Cell Rule List is to restrict the types for each value (e.g., Number).

   You can create an Upload Button in Components using the defined Excel Template and Excel Work, and then set up an Excel Import Service to use it.