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

Excel find Column

Hi,

 

i try to find a column with iLogic. I got two Headlines in the first row of my Excel. "Type 1" and "Type 2". Also a Parameter in Inventor "Type" which has the Inputs "Type 1" and "Type 2"

 

The Headlines are in Column A and B. It the Parameter in Inventor is "Type 2" so my result should be coulum "B".

 

Is there a way to do that?

 

Kind regards

bradeneuropeArthur
in reply to: mk92

No I logic is needed.
Embed the excel list or link it to the inventor part or assembly.
The parameters in excel are now visible inventor

Regards,

Arthur Knoors

Autodesk Affiliations:

Autodesk Software:Inventor Professional 2025 | Vault Professional 2024 | Autocad Mechanical 2024
Programming Skills:Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Programming Examples:Drawing List!|Toggle Drawing Sheet!|Workplane Resize!|Drawing View Locker!|Multi Sheet to Mono Sheet!|Drawing Weld Symbols!|Drawing View Label Align!|Open From Balloon!|Model State Lock!
Posts and Ideas:Dimension Component!|Partlist Export!|Derive I-properties!|Vault Prompts Via API!|Vault Handbook/Manual!|Drawing Toggle Sheets!|Vault Defer Update!


! For administrative reasons, please mark a "Solution as solved" when the issue is solved !

mk92
in reply to: bradeneuropeArthur

Thanks for your answer. Unfortunately i need to do it with iLogic because i cant embed the Excel Sheet in my case.