Import System Requirements from Excel

Agilian supports exporting and importing Microsoft Excel file. You can edit model element names and properties easily within Excel. This article is going to show you how to export requirement diagram to Excel file, edit properties and create a few more requirements in tabular format, and then import them back to Agilian.

1. Create a requirement diagram.
2. Create a requirement through diagram toolbar. Name it as Support HTML Reply.
   

   Create a requirement

3. Double click kind to select Functional. Similarly, select Test for verifyMethod and Medium for risk.
   

   Enter properties

4. Let’s export this requirement diagram to Excel. Select File > Export > Excel… from the main menu.
   

   Export Excel

5. In the pop-up Export Excel dialog box, specify the output path for Excel file and check the diagram you want to export.
   

   Specify output and check diagram

6. Click Export button.
7. When the Excel file is opened, change the risk of the requirement to low. Double click on it and type Low.
   

   Type Low in risk

8. Next, create three more requirements: Disallow Javascript, Text Limit Control and Disallow Image. For Disallow Javascript, type Don’t let users to use Javascript in text, enter 2 in ID, type Functional in kind, type Test in verifyMethod and type Low in risk. For Text Limit Control, type The number of words must be between 100 and 500 in text, enter 3 in ID, type Functional in kind, type Test in verifyMethod and type Medium in risk. For Disallow Image, type Don’t let users to insert images in text, enter 4 in ID, type Functional in kind, type Test in verifyMethod and type Low in risk.
   

   Add three requirements

9. Save the Excel file.
10. Now, import the Excel file back to Agilian. Select File > Import > Excel…from the main menu.
    

    Import Excel

11. In the Import window, you can see the risk of Support HTML Reply is updated. Three requirements are created. Click OK button to proceed importing.
    

    The Import dialog box

12. As a result, the Excel file is imported to the requirement diagram.
    

    The imported requirements

How to try the sample

Download requirement-sample and then unzip it to get the .vpp file.