Hi,

I'd like to link the dimensions of a parametric sketch to an external file (i.e. an excel spreadsheet or a text file) and automatically update the cad file when the external file is changed.

I tried with a design table but if I change the spreadsheet the values are not updated in SW. Another way would be using equations but I couldn't find a way to import them from an external file. 

for the moment this is just an experiment but I will eventually need to perform a design optimization following the steps:

1 generate set of parameters (for example in excel or matlab)

2 update the geometry in SW and save the new version in a format suitable for fluid dynamic analysis

3 run CFD

4 close the loop

I've never used macros or api so far so I'm open to any suggestion about the most efficient solution to my problems

thanks for your help