Inventor General Discussion

Inventor General Discussion

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

iLogic syntax for searching in excel and update the iproperties

183 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: 359
Registered: ‎05-20-2008
Message 2 of 3 (173 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 (156 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

 

 

 

 

 

 

 

 
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!