Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Create a Rule to extract data from Excell

2 REPLIES 2
SOLVED
Reply
Message 1 of 3
exSWX
310 Views, 2 Replies

Create a Rule to extract data from Excell

I'd like to create a rule to extract data from an Excel Spreadsheet cell and have it update an anotation in a drawing.

 

What I have is a spreadsheet of several Product Sizes which drive a model.

 

I want to make a drawing of the model and on the drawing have a note as to which Product the drawing is refering to.

 

I have made the drawing, which updates when I change the referenced look up files in the spreadsheet. All good.

However I need to have a note indicating which Product is being shown in the Drawing.

 

See attached.

 

I have no experience of iLogic Rules, so this is a little above me.

 

Can anyone offer any help?

Autodesk Inventor 2021
Intel Xeon W3520 @ 2.67GHz
Win 10 Pro
6.7 System Rating
NVIDIA Quadro FX 1800
2 REPLIES 2
Message 2 of 3
karthur1
in reply to: exSWX

I'm no whiz at ilogic either, but thought I'd give it a try.

 

Here is the code from my ilogic rule.

 

2014-08-09_2137.png

 

When I run it, it copied the value in the B3 cell and puts it in the custom properties of the idw.  Then format your text to use this custom parameter.

 

2014-08-09_2131.png

 

 

Hope it helps,

Kirk

 

 

Message 3 of 3
exSWX
in reply to: karthur1

Thanks Kirk,

That's just what I needed.

Autodesk Inventor 2021
Intel Xeon W3520 @ 2.67GHz
Win 10 Pro
6.7 System Rating
NVIDIA Quadro FX 1800

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report