Exporting and importing Excel

Visual Paradigm supports interoperability with Excel file. You can export project data to an Excel and edit it externally. In this chapter, you will see how to export and import Excel through the command line interface.

Exporting Excel

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

Importing Excel

To import Excel to 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 ImportExcel 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:
   ImportExcel -project C:\Demo\Demo.vpp -file C:\Demo\input\sample.xlsx
   
   Below is a description of parameters:
   

   Parameter Description Example -project Project path C:\Demo\Demo.vpp -file The filepath of the Excel file to import C:\Demo\input\sample.xlsx

   Parameters for ImportExcel

Related Resources

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

• New to Visual Paradigm? We have a lot of UML tutorials written to help you get started with Visual Paradigm
• Visual Paradigm on YouTube
• Visual Paradigm Know-How - Tips and tricks, Q&A, solutions to users' problems
• Contact us if you need any help or have any suggestion