• Blog posts

    Bio

    By Gus Petrikas

    If you ever find yourself in a position were you have to change a property of a component after you finish your drawing, here are a couple of ways to do just that.  The obvious one would be to edit the components one-by-one using the Edit Component command, but that could be really time consuming, if you are working on a bigger project. The second, much faster solution to the problem would be to edit all the components at once, using Excel: 

    •  Inspect the components that need to modified. For the purpose of this demonstration I am going to change the Rating of these circuit breakers.  

    • Navigate to the Import/Export Data tab on the ribbon and select To Spreadsheet. 

    • Choose the data category that needs exporting. In this case - Components.

    • Choose the preferred format. I would recommend .xls as it is very easy to edit the exported file. 


    • Then, pick the files that will be included in the spreadsheet and hit OK.

    • You should now have an exported spreadsheet with all the Component information. Open the spreadsheet and make the necessary modifications.  

    • Save and exit. 
    • Navigate back to the Import/Export Data tab and click From Spreadsheet

    • Choose if the changes need to be made to the Project or the Active Drawing and hit OK. 

    • The drawing should automatically display the new, updated component values.