Hide Table of Contents

Import from Excel

Menu: Import/Export > Import from Excel

 

This feature allows you to import specific Excel files to update electrical electrical project data. These Excel files must come from an Export to Excel managed by SOLIDWORKS Electrical.

 

Like the export to Excel , the Import from Excel command uses a wizard to help you manage the data import.

Step 1: Welcome to the Excel import wizard

 

Add: Allows you to select the Excel file you want to import. A selection dialog box opens in which you can select one or more Excel files.

Remove: Allows you to remove the selected Excel file.

 

The Excel file is compared with the saved point created during the export. If you try to import an Excel file in which you didn't modify data, a dialog box opens telling you that is not necessary to import the file.

If you wish to import several Excel files containing the same data type, you cannot import these files at the same time.

If the original saved point isn't found, you can also import the file. Data is compared with the data stored in the electrical project database.

Step 2: Select object to import

The second step of the wizard displays the list of changes and conflicts. You can find one tab per modified data type.

Each tab displays the list of modified elements.

When a change is possible, the value is displayed in a green cell.

In the first column (check the box), select the elements you want to import. If you don't select an element, the value in the electrical project database is preserved.

 

In the final step of the wizard, a dialog box opens asking you if you want to delete or keep the saved point.

Conflict management

If data was modified in the electrical project since the Excel export and modified in the Excel file, there is a conflict, which will be identified in red with a specific icon.

Edit conflict: Select the cell displaying the conflict and click the Edit conflict button. A dialog box opens, allowing you to select the data you want.

- Value from project: The value displayed comes from the database electrical project.

- Value from imported file: The value comes from the Excel file.

- Original value: The value comes from the saved point.

Display only conflicts: This option, when activated, displays only the elements that are conflicting.



Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

 
*Email:  
Subject:   Feedback on Help Topics
Page:   Import from Excel
*Comment:  
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:




x

We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again
x

Web Help Content Version: SOLIDWORKS Electrical 2022 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.