Link to excell file and SW part

Out of category
1

Hello everyone,

 

I would like to control the dimensions of my SW file (length, width, height, deletion of such and such a component...)  by an exell file.

 

How do I create a link between my excellency file and SW?

 

Because what I would like is to enter these values in exell, that it reconstructs my SW file to the new dimensions because at the same time in my exell file it would come to look for various information in relation to the dimensions entered.

 

Thank you in advance for your help.

 

 

1 Like
2

See this tutorial 

 http://www.lynkoa.com/tutos/3d/creation-des-propriete-de-toolbox-avec-excel

@+ ;-)

3 Likes
3

Here is an example that makes the entire process

reading value / modifying value

There is the code to do, just to adapt, good luck ...

 

 


macro_excel.zip
10 Likes
4

Good evening

 

To link your excel file, simply click on insert/tables/part family.

 

Then check the "from file" option in the "Source" tab

 

I attach an image illustrating this manipulation.

 

All that remains is to match the names of the ribs and function.

 

See Solidworks Help for details.

 

http://help.solidworks.com/2014/french/solidworks/sldworks/t_inserting_file_design_table.htm

 

 


famille_de_piece.png
6 Likes
5

Hello

 

When I create a family of rooms, for simplicity and when you already have the existing room:

  • I create a second configuration
  • In this one I modify all the dimensions that are led to change from one configuration to another
  • finally I create the part family with "Insert > Tables > Room Family" but choosing the automatic creation

 

This way, you don't have to create a family of parts by hand because SolidWorks takes care of it!

3 Likes
6

To complete the answers...

 

you can create a part family, save it as an external file, delete the part family, insert a new part family from a file, by checking the "link to file" option, so you can modify the file without Solidworks (just with excel) and when the 3D file is loaded into Solidworks there will be a reading of the excel file and an update of the configurations...

 

I chose to create a part family, save it and delete it to first use automatic creation... And having the right syntax... Otherwise you can prepare the excel file without Solidworks if you are sure of your parameters and insert the part family by linking it after...

4 Likes
7

Hello.

I take the liberty of reopening the subject because it is the title that fits best.

So for the record, Solidworks 2017 and Excell 2016.

I am in the process of creating my database with the standard profiles of my supplier for mechanically welded construction.

To do this, I create a profile that I add to my library (sldlfp) and then I "glue" a family of parts to it via excell in order to draw only one profile and to enter all the possible dimensions on the spreadsheet.

My questions are:

- Or Solidworks hides this excell file, because I can only access it via solidworks. Well I think...

-If I delete my profile from the library, is my excell file deleted too?

Thanks in advance;)

8

The file is saved in the room and you can save it outside of it by right-clicking on the room family file and then saving the room family. Then afterwards you right-click again on the part family in your part then edit the function and in source you select from the file and you select the file that has just saved so you open the excel file and add line and when opening the part the different sides will  update.

9

Hello

Check out this video which is well done.

https://www.youtube.com/watch?v=aGZTv99R4hE

may the force be with you.