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:
Here iam using different rules for plate, flat, round, etc.,
Thanks in Advance.
Thanks & Regards,
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")
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
Access a broad range of knowledge to help get the most out of your products and services.