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.

 
3. Exporting and importing XML Table of Contents 5. Generating ORM code and/or database

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