Import Table in Value Collaborator

Overview

When you need to add a table with 15 or more rows, the best option is to use the import table feature rather than creating a table manually.

Step-by-Step Guide

Creating Excel Table

1. Open a new Excel worksheet. Name the sheet as UI BUILDER.

   

   
   

2. Name the first column as Section Name and enter the section names appropriately. Whether it is a tab, section, or category (if any), you have to be specific when naming it. The format is <tabname>:<sectionname>:<categoryname>

   
   

3. Name the second column as Table. If more than 1 table needs to be created, ensure to number the table as 1,2, 3, and so on.

   
   

4. In the next columns enter variable names and code references respectively.

   

   
   

5. Ensure not to leave any column blank in any of the rows. otherwise, when the Excel table is uploaded, the below values will automatically take the blank space in the cells.

   
   
6. If at all you need to leave the column blank, click the spacebar to enter space in the cell.

Uploading Excel Table

1. Follow the steps to Upload your Model/Create a Visualizer Type.

   

   
   

2. Click Value Collaborator on the Visualizer Type page.

   

   
   

3. Select the specific tab, section, or category (if any) where you want to import a table.

   

   
   

4. Click Import Table on the top navigation.

   

   
   

5. Click Choose File to upload the Excel table.

   
   

6. Click Import. The table gets imported.

   
   

7. Click Save on the top navigation.

   

   
   
8. Click Prototype and click the exact tab, section, or category to see the newly imported table.

Editing the Excel Table

You can directly make the edits in Value Collaborator.