Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Anonymous
328 Views, 2 Replies

Ilogic for changing partno from a excel

I Was looking for a ilogic code which can help in changing some of the part numbers in an assembly as per the excel sheet, For Example : We have an assembly with 35 Components and 5 Sub assemblies  - I need to check the part no's with 1st column in the excel - if exists then i need to change the number to the 2nd Column as per the excel file attached. 

 

 

johnsonshiue
in reply to: Anonymous

Hi! Certainly this can be done programmatically or iLogic. But, it can also be done manually without too many clicks. Simply open the assembly and go to BOM table. Sort by certain property. You can actually copy from Excel cells and paste them directly to BOM Part Number column.

Many thanks!



Johnson Shiue (johnson.shiue@autodesk.com)
Software Test Engineer
Anonymous
in reply to: johnsonshiue

Actually the same list in the excel needs to be done for around  60 - Assemblies - Which will take more time to open and do that to each BOM