Exporting and importing Excel with command

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. Start the command prompt.
3. Execute the script by supplying the required parameters. For example:
   ExportExcel -project C:\Demo\Demo.vpp -out C:\Demo\Output\Sample.xlsx

   Parameter	Description	Example
   -project	Project path	C:\Demo\Demo.vpp
   -out	The filepath of Excel file	C:\Demo\Output\Sample.xlsx

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. Start the command prompt.
3. Execute the script by supplying the required parameters. For example:
   ImportExcel -project C:\Demo\Demo.vpp -file C:\Demo\input\sample.xlsx

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