◷ Reading Time: 3 minutes
Import a Decision Table from an Excel Document
You can import Excel documents for the Decision Table Visual Designer.
How to Import
First, create a blank Decision Table document using the dialog shown below:
Then you select Import from the Toolbar
The following message will be prompted as a warning as the decision table will be replaced with the decision table from the excel file.
Select your Excel file with the browse button and choose your worksheet.
The top left corner of your table must start with either of the following keywords:
The import is sensitive to the start of the table and will recognize an area as a Decision Table once it identifies either of these keywords in any cell.
Then press OK and a Row Type Selector screen appears. This screen (shown below) allows you to mark each row with an appropriate type.
Once the types are all set and no unknown rows are on your screen, then you can press the OK button and wait until the process is finished.
You might see additional massages depending on the decision table you input. You can press OK to continue.
And you will have the Excel document imported:
Export a Decision Table to an Excel Document
You can export a decision table document to an Excel file.
Click on Export under Excel.
Give a name to the Excel file and select a file location.
You can see the exported Excel file as follows.
Downloadable Sample Excel file
Download a sample Decision table Excel file using the attachment.