iLogic - Colour Parts in Assembly

[Anonymous]

Hi,

I'm looking to change the part appearances at assembly level via a excel spreadsheet. 

The current code I've got works fine for a individual part. However, there is over 100 panels per assembly.

How do I make the code Loop/Catch/Map/For Each through the range of the 100+ excel entries?

TEST = GoExcel.CellValue("C:\Users\person\Documents\Book1.xlsx", "Sheet1", "C2") 

TEST_2 = GoExcel.CellValue("C:\Users\person\Documents\Book1.xlsx", "Sheet1", "D2")

Component.Color(TEST & ":1") = TEST_2

TEST = Browser part name in assembly

TEST_2 = Colour/Appearance name required for assembly.

Cheers

[chandra.shekar.g]

@Anonymous,

Hoping that below blog article link may be helpful.

https://knowledge.autodesk.com/search-result/caas/CloudHelp/cloudhelp/2018/ENU/Inventor-API/files/SetOccurrenceAppearance-Sample-htm.html

Thanks and regards,