{"id":2657,"date":"2015-02-02T10:17:56","date_gmt":"2015-02-02T10:17:56","guid":{"rendered":"http:\/\/www.solidapps.co.uk\/blog\/?p=2657"},"modified":"2015-11-03T16:27:34","modified_gmt":"2015-11-03T16:27:34","slug":"solidworks-electrical-2015-excel-exportimport","status":"publish","type":"post","link":"https:\/\/www.solidapps.co.uk\/blog\/2015\/02\/solidworks-electrical-2015-excel-exportimport\/","title":{"rendered":"SOLIDWORKS Electrical 2015 \u2013 Excel export\/import"},"content":{"rendered":"

An article by Maria Ion<\/strong>, Technical Customer Support Engineer.<\/p>\n

Excel export\/import it is a new feature in SOLIDWORKS Electrical 2015. This feature allows you to manage project data outside SOLIDWORKS Electrical.\u00a0Data is exported via an Excel file in which you can modify marks, user data, manufacturer part data, etc. Afterward, this data is imported to the project to be compared with the project data. The user validates the changes or can keep the original data. To export or import data, this feature uses Excel file templates. In these files, the user defines the type of data managed by the export\/import.<\/p>\n

1. Create a new Excel template<\/strong><\/h2>\n

In order to create a new excel template , go to \u201cProject<\/strong> \/ Configurations<\/strong> \/ Excel export<\/strong> \/ import\u2026<\/strong> \/ New<\/strong>\u201d, or from the \u201cSide panel \/ Contextual menu of Project: Configurations<\/strong> \/ Excel export<\/strong> \/ import\u2026<\/strong> \/ New<\/strong>\u201d.\u00a0A wizard opens allowing creation of a new template for the Excel export\/import.<\/p>\n

The General<\/strong> tab allows you to enter the file name, to select the file extension corresponding to your Excel version and to enter the description of the template. You can click the icon to select the language managing the description.<\/p>\n

\"Screen<\/p>\n

The left part of the Selection<\/strong> dialog box displays the list of elements containing data. This area gives you the possibility to select the objects you want to manage.\u00a0The right part displays the data (user data and translatable data) associated with the selected objects.<\/p>\n

\"Screen<\/p>\n

The Finish<\/strong> tab displays the summary of exported data. It indicates the number of exported fields for each table.\u00a0A check box, if it\u2019s activated, allows you to open the file (you must have Excel to open it) when you click the Finish<\/strong> button.<\/p>\n

\"Screen<\/p>\n

2. Export to Excel<\/strong><\/h2>\n

The first step of this wizard allows you to select the templates to use.<\/p>\n

\"Screen<\/p>\n

Check the box to select the Excel templates you want to export and click the Next<\/strong> button to continue.
\nThe next step is to select the destination folder: Click the icon and select a directory where you want to save Excel files.\u00a0Then, Click the Finish<\/strong> button to launch the export.<\/p>\n

3. Modify data within Excel<\/strong><\/h2>\n

SOLIDWORKS Electrical allows you to export the project data to Excel files.
\nThese files are formatted to be used by SOLIDWORKS Electrical. Some precautions must be taken, otherwise you will not be able to import the data. (more information can be found in the HELP menu \u2013 Modify data within Excel).<\/p>\n

After the\u00a0changes have been made in the excel sheet, ( i.e : change the Location mark to Manual by changing the value \u201c0\u201d to \u201c-1\u201d, and change the Location mark from L1, L2 , to L10 and L20), the changes can be implemented into the project by importing the Excel file.
\n\"Screen
\n\"Screen<\/p>\n

4. Import from Excel<\/strong><\/h2>\n

This feature allows you to import specific Excel files to update project data. These Excel files must come from an Excel export managed by SOLIDWORKS Electrical.<\/p>\n

Like the Excel export, the Import from Excel<\/strong> command uses a wizard to help you manage the data import.\u00a0Welcome to the Excel import wizard<\/strong> 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.<\/p>\n

\"Screen<\/p>\n

After the object to import has been selected the wizard displays the list of changes and conflicts. Each tab displays the list of modified elements.<\/p>\n

\"Screen<\/p>\n

When a change is possible, the value is displayed in a green cell.\u00a0In the first column (check the box), select the elements you want to import. If you don\u2019t select an element, the value in the project database is preserved.<\/p>\n

In the final step of the wizard, a dialog box opens asking you if you want to delete or keep the snapshot.
\nThe initial location mark. (L1 and L2)<\/p>\n

\"Screen<\/p>\n

The location mark after importing the excel file. (L10 and L20)<\/p>\n

\"Screen<\/p>\n

Location properties \u2013 The Location marking mode has been changed from Automatic<\/strong> to Manual.
\n<\/strong>
\n\"Screen<\/p>\n

Using the new Excel export\/import function in SOLIDWORKS Electrical 2015, the project changes can be applied externally and automatically populated across the project.<\/p>\n

In this way, export to XLS captures user defined project data, afterwards the XLS file can be modified to reflect change requirements outside the SOLIDWORKS Electrical environment and then import from XLS imports revisions direct to the project data set.<\/p>\n

Originally posted by Julien Boissat in the SOLIDWORKS Blog<\/a>.<\/p>\n

\"DoubleRedArrow\"<\/a>\u00a0Find out more on SOLIDWORKS Electrical<\/span><\/a>
\n\"DoubleRedArrow\"<\/span><\/a>\u00a0Contact Sales<\/span><\/a>
\n\"DoubleRedArrow\"<\/span><\/a>\u00a0Request a Demo<\/span><\/a><\/p>\n

\"REP_3Dfor2DEngineering_Analyzing_Assemb_600x90_SAL\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

An article by Maria Ion, Technical Customer Support Engineer. Excel export\/import it is a new feature in SOLIDWORKS Electrical 2015. This feature allows you to manage project data outside SOLIDWORKS… <\/p>\n","protected":false},"author":1,"featured_media":2658,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[118],"class_list":["post-2657","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-solidworks-electrical","tag-solidworks-electrical"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/posts\/2657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=2657"}],"version-history":[{"count":4,"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/posts\/2657\/revisions"}],"predecessor-version":[{"id":3728,"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/posts\/2657\/revisions\/3728"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/media\/2658"}],"wp:attachment":[{"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=2657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=2657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.solidapps.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=2657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}