Excel find Column

Excel find Column

mk92
Collaborator Collaborator
350 Views
2 Replies
Message 1 of 3

Excel find Column

mk92
Collaborator
Collaborator

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

0 Likes
351 Views
2 Replies
Replies (2)
Message 2 of 3

bradeneuropeArthur
Mentor
Mentor
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 & Links:
blue LinkedIn LogoSquare Youtube Logo Isolated on White Background


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:
My 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 !


 


EESignature

0 Likes
Message 3 of 3

mk92
Collaborator
Collaborator

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

0 Likes