Jump to Menu

How to Edit Model Elements with Excel?

Export project to Excel file to take advantage of its extensive built-in functions to perform analysis, calculations and generate charts to read the models from a different perspective. Besides, you can update the exported Excel file and import it back to synchronize the changes to models.

Compatible edition(s): Enterprise, Professional, Standard, Modeler

  • February 02, 2016
  • Views: 24,084
  • PDF

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.
    Export Excel window
  4. Select an Export Style. We will try Model type per sheet this time.
    Select Model Type per Sheety
  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.
    Open worksheet
  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..
    Use formulae

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".
    Modify cell
    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.
    Perform importing
  5. The model is updated following the change made in Excel.
    Element rneamed

Turn every software project into a successful one.

We use cookies to offer you a better experience. By visiting our website, you agree to the use of cookies as described in our Cookie Policy.