Chapter 27. Export and Import

  1. Home
  2. Docs
  3. Chapter 27. Export and Import
  4. 5. Command-line Interface
  5. Exporting and importing Excel with command

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