MultiValue from Linked Excel spreadsheet

[Anonymous]

Hey All,

Is it possible to link a multivalue parameter to inventor from an excel spreadsheet?

[Anonymous · Accepted solution]

Yes, this is pretty easy to do, and using the standard iLogic snippets too

XLS = "C:\Temp\Excel.xlsx"

MultiValue.List("Name") = GoExcel.CellValues(XLS, "Sheet1", "A2", "A10")

In the code above, my user parameter is called "Name". Below is a picture of the Paramters as well as the Excel that the data was pulled from.

[Anonymous]

Awesome!!!