Exporting diagrams to Microsoft Excel format

Interoperability is the ability to exchange information between two systems and to use the information that has been exchanged. Visual Paradigm supports interoperability with Microsoft Excel file. You can export project data to an excel file, make changes in exported Excel's worksheets or further processing like to query data with formula and eventually, feed the changes back to Visual Paradigm. In this chapter, you will see how to export an Excel file from a project. To export Excel:

  1. Select Project > Export > Excel... from the toolbar. This opens the Export Excel window.
  2. Specify the output path of Excel file.
  3. Select the diagrams to export to Excel.
  4. On the Model Types list at the right hand side, you can optionally select the type(s) of model elements to be exported.
  5. Click Export. Upon finishing, you can visit the output destination specified to obtain the Excel file.
    The exported Excel file
    The exported Excel file

An overview of Export Excel window


Overview of the Export Excel window
No.Field Description
1 Output Path The file path of the Excel file.
2 Launch Editor Check to open the exported Excel file after exported.
3 Export Style Determine how data will be presented in Excel.
Diagram Per Sheet - Selected diagrams will be exported to separate sheets.
All in One Sheet - Selected diagrams will be exported to a single sheet.
Model Type Per Sheet - Selected model elements will be exported to separate sheets, grouped by type.
Raw - Only one sheet will be generated with all elements listed in it. All the properties of selected elements will be listed as columns in which each row represents a model element.
4 Export Tagged Values Tagged values can be added to model elements to specify domain specific properties. You can add tagged values in the specification window of model element. Check Export Tagged Values if you want to export tagged values of model elements.
5 Export Comments You can add your own comments to model elements in their specification window. Check Export Comments if you want to export the comments to the Excel file.
6 Export PM Properties PM properties is the short form of project management properties. You can set project management properties, such as version, phrase, author, in the specification window of a model element. Check Export PM Properties if you want to export PM properties of model elements.
7 Export Test Plans Test plan refers to the test plans that can be specified for Test Case elements in requirement diagram. Check Export Test Plans to export the information of test plan to a separate sheet in Excel file.
8 Export Table Records You can specify the table records of entities created in ERDs. Check Export Table Records to export these table records.
9 Model Elements Select this tab and check the model elements you want to export to Excel.
10 Diagrams All diagrams in the opening project are listed here. Select the diagrams to export to Excel.
11 Model Types Check or uncheck model types to include and exclude the types of model elements in exporting.
12 Model Types When you have updated the diagram selection in Diagrams list, the Model Types list will be updated to list the types of diagram elements that appear in the chosen diagrams. By default, all diagram element types are checked, meaning that diagram elements in those types will be exported to Excel. You can uncheck type(s) to ignore certain type(s) of diagram elements when exporting.
13 Export Click Export to proceed with exporting Excel.
14 Cancel Click Cancel to diacard exporting to Excel.
Overview of the Export Excel window

Exporting diagrams to Microsoft Excel with command line interface

To export Excel from a project through command line:

  1. Browse the scripts folder under the Visual Paradigm installation directory. For Mac users, you can find the scripts folder in the Visual Paradigm package by right clicking on it and then selecting Show Package Contents. Then look in Contents\Resources\app\scripts for the scripts folder.
  2. Copy the script file ExportExcel and paste to the bin folder of Visual Paradigm installation directory.
  3. Start the command prompt.
  4. Navigate to the bin folder of Visual Paradigm installation directory.
  5. Execute the script by supplying the required parameters. For example:
    ExportExcel -project C:\Demo\Demo.vpp -out C:\Demo\Output\Sample.xlsx

    Below is a description of parameters:
    Parameter Description Example
    -project Project path
    C:\Demo\Demo.vpp
    -out The filepath of Excel file
    C:\Demo\Output\Sample.xlsx
    Parameters for ExportExcel

Related Resources

The following resources may help you to learn more about the topic discussed in this page.

 
Chapter 3. Export and Import Microsoft Excel Table of Contents 2. Importing Microsoft Excel file

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.OK