Part I. Getting started

Part II. UML modeling

Part III. Project glossary

Part IV. BPMN toolset

Part V. Project management

Part VI. Modeling toolset

Part VII. ArchiMate tools

Part VIII. Team collaboration

Part IX. Code engineering

Part X. Database design and engineering

Part XI. Advanced modeling toolset

Part XII. Document production

Part XIII. Business modeling

Part XIV. Business rule

Part XV. Agile development

Part XVI. Wireframe

Part XVII. Impact analysis

Part XVIII. CMMN toolset

Part XIX. SoaML modeling

Part XX. Design animation

Part XXI. IDE Integration

Part XXII. Interoperability and integration

Part XXIII. Process simulation

Part XXIV. Zachman and BMM

Part XXV. Appendix A - Application Options

Part XXVI. Appendix B - Project Options

Part XXVII. Appendix C

 

Importing Microsoft Excel file

You can import changes made externally in Excel file back to Visual Paradigm, to update the project data. In this chapter, you will see how to import an Excel exported before. Notice that Excel import is made in response to Excel export in Visual Paradigm. Only Excel exported from Visual Paradigm can be imported.

Importing an Excel file

  1. Select Project > Import > Excel... from the toolbar.
  2. In the file chooser, select the Excel file to import and click Open to confirm.
  3. In the Import window, you can preview the changes you have made in the previous Excel file. If you want to keep a record of changes, click on Save Details... at the bottom of window to export the changes to an Excel file.
    Import window
    Import window
  4. Click OK button to proceed.

Importing Excel to project with command line interface

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.

 
1. Exporting to Microsoft Excel Table of Contents 3. Excel modification guidelines

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