How to Edit Model Elements with Excel?

In this tutorial you will learn how to export several classes into Excel, make changes, and then import the changes back into Visual Paradigm.

Exporting to Excel

1. Select Project > Export > Excel... from the application toolbar.
2. Enter the output path of the Excel file in the Export to Excel window,
3. Select the diagram(s) to export to Excel.
   
4. Select an Export Style. We will try Model type per sheet this time.
   
5. Click Export.
6. An Excel file is produced. Open it.
7. Since we selected the model type per sheet option, data is organized in each sheet by model type. Open the worksheet Class.
   
8. You can then type some formulae to perform calculations. For example, the picture below shows a formula that calculates the sum of classes whose name has "controller" in it..
   

Importing an Excel file

1. We can modify the data and then import it back to modeling tool to update the models. For example, change class name from "Writer" to "Author".
   
   Note: If you want to insert some extra content to the exported Excel file instead of modifying just model properties, make sure it won't disrupt the exported content. Otherwise, the file may not be able to import back to the source project. To avoid disrupting the exported data, enter in a far away cell. The best position would be at least the fifth row below the last content.
2. Save the file.
3. Go back to Visual Paradigm. Select Project > Import > Excel... from the application toolbar.
4. The Import window shows what changes will be made to the models. Click OK to confirm.
   
5. The model is updated following the change made in Excel.