iLogic syntax for searching in excel and update the iproperties

[linuskotte]

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)

   

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

Thanks in Advance.

Thanks & Regards,

LINUS KOTTE

[Yijiang.Cai]

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")

[linuskotte]

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")

in showing 3 sheets also same data

Thanks & Regards

LINUS KOTTE