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. VP-UML 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 VP-UML. In this chapter, you will see how to export an Excel file from a project. To export Excel:

Select File > Export > Excel... from the main menu.
This opens the Export Excel dialog box.
Specify the output path of Excel file.
Select the diagrams to export to Excel.
On the Model Types list at the right hand side, you can optionally select the type(s) of model elements to be exported.
Click Export. Upon finishing, you can visit the output destination specified to obtain the Excel file.

The exported Excel file

An overview of Export Excel dialog box

Overview of the Export Excel dialog box

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, 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 dialog box 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 dialog box. 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 dialog box 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	Model Elements	Select this tab and check the model elements you want to export to Excel.
9	Diagrams	All diagrams in the opening project are listed here. Select the diagrams to export to Excel.
10	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.
11	Export	Click Export to proceed with exporting Excel.
12	Cancel	Click Cancel to diacard exporting to Excel.

Overview of the Export Excel dialog box

Chapter 3. Export and Import Microsoft Excel

Table of Contents

2. Importing Microsoft Excel file