Link text from a spreadsheet to an iProperty?

[SveinE]

I can link numeric values from a spreadsheet to parameters.
However, is there a way to link text from a spreadsheet into iProperties (or
anywhere else as text)? I'm trying to administrate general information\metadata from a
spreadsheet.

I do not think this is possibible from within Inventor, but maybe someone have an macro\ilogis\vba code that do this??

br

Svein

[Curtis_Waguespack · Accepted solution]

Hi SveinE,

Here is an example iLogic rule to do this:

GoExcel.Open("C:\Temp\MyExcel_WB", "Sheet1")
iProperties.Value("Project", "Part Number") = GoExcel.CellValue("B1")
iProperties.Value("Project", "Description") = GoExcel.CellValue("B2")
iProperties.Value("Project", "Revision Number") = GoExcel.CellValue("B3")
iProperties.Value("Summary", "Comments") = GoExcel.CellValue("B4")

 where the excel data looks like this:

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com

[SveinE]

Thanks Curtis

It looks like this will dp the trick.

I will try and let you know 🙂

br

Svein