Inventor General

Reply
Valued Contributor
linuskotte
Posts: 66
Registered: ‎01-23-2012
Message 1 of 3 (142 Views)

iLogic syntax for searching in excel and update the iproperties

142 Views, 2 Replies
12-17-2013 08:39 PM

Hi,

 

I want a illogic rule syntax for following process:

 

I have one excel sheet it consists around 5 sheets for Plate, Flats, Rounds, etc.,

When iam run the rule then it will ask and do the following:

  1. Ask the thickness value.
  2. It will search thickness value in “D:\LINUS KOTTE\stock numbers.xlsx” in sheet 1
  3. If thickness value found then fill the stock number in iproperty(project tab-stock number)

 

EXCEL2.JPG  EXCEL1.JPG 

 

Here iam using different rules for plate, flat, round, etc.,

 

Thanks in Advance.

 

Thanks & Regards,

LINUS KOTTE

Employee
Yijiang.Cai
Posts: 350
Registered: ‎05-20-2008
Message 2 of 3 (132 Views)

Re: iLogic syntax for searching in excel and update the iproperties

12-17-2013 09:27 PM in reply to: linuskotte

Please see the iLogic rule below, and this rule will get the vaule of stock number in excel when Thickness =1, then the value of stock number will be filled in the stock number in iProperty within part. And you could modify the 1 to other value.

i = GoExcel.FindRow("D:\LINUS KOTTE\stock numbers.xlsx", "Sheet1", "Thickness", "=", 1)
iProperties.Value("Project", "Stock Number") = GoExcel.CurrentRowValue("Stock Number")
Thanks,
River Cai

Inventor Quality Assurance Team
Autodesk, Inc.
Valued Contributor
linuskotte
Posts: 66
Registered: ‎01-23-2012
Message 3 of 3 (115 Views)

Re: iLogic syntax for searching in excel and update the iproperties

12-18-2013 02:31 AM in reply to: Yijiang.Cai

EXCEL3.JPG

 

 

It showing error message how to solve this

 

I copied into ilogic editor and run then it shows this message

 

i = GoExcel.FindRow("D:\Book1.xlsx", "PLATE",  "Thickness", "=", 1)
iProperties.Value("Project", "Stock Number") = GoExcel.CurrentRowValue("Stock Number")

 

EXCEL4.JPG

 

in showing 3 sheets also same data

 

Thanks & Regards

LINUS KOTTE

 

 

 

 

 

 

 

 

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube