Inventor General Discussion

Inventor General Discussion

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

iLogic syntax for searching in excel and update the iproperties

198 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 (188 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 (171 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
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.