Automating Weight Transfer from XLSX to Parts List in Inventor

[max.baumann07]

Hello everyone,

I have an XLSX file that is linked to the components in my project. There are two components that serve as placeholders and are currently empty: "Grease" and "Spring."

I need to transfer the weights of both components from the XLSX file into the parts list. I managed to do this for "Grease" by creating an iProperty called "Weight_Grease," retrieving the parameter from the XLSX file, and storing it in the parts list.

This works perfectly for "Grease."

However, I'm not sure how to do the same for the weight of the "Spring."

The weights must be automatically taken from the XLSX file and should not be manually entered into the drawing or the model. I need a solution that ensures an automated process between the XLSX file and Inventor.

Any advice or guidance on how to achieve this would be greatly appreciated.

Best regards
Max

[C_Haines_ENG]

You should look into Excel Data Links. This will allow you to retrieve the exact value you need from excel. 

You can cycle through the parts list rows for the matching parts, and then change the column value to that from excel. If you need the extra help I should be able to create something simple for you to reference. If that the case, could you upload images of the excel file and parts list?

[max.baumann07]

This is my xlsx.

My drawing.:

The Spring and Grase are empty parts. The weight from the Spring comes from a replacemant.