Get total Length fra Excel form inventor, How

[Darkforce_the_ilogic_guy]

I have a excel sheet that have all the Raw materiel("A" Row ) nummer(custom properties by the same name,) and the length of each part is in the files as Custom Properties call G_L. To. it that a way go thoung the list of raw material form the Excel and add the total length to the "D" row   ? for each raw materie

[theo.bot]

I would say this is possible. I think you have to loop thru each row in the "parts only view" of the bill of material. Get the iproperty with your code and store the G_L multiplied by the item qty to a variable. If you find in a new row the same material code, add the Length value to your variable. after you grab all total lengths, you can lookup the code in excel and add the right value in excel column D. 

Here is a sample ilogic rule how to loop thru a BOM: Solved: Iterate through a BOM and display a quantity for every part - Autodesk Community - Inventor
for the excel find part you can use the standard system snippets