ilogic excel confusion

[chrisjspower]

I am aware of the function that allows one to link an excel spread sheet to their parameters table in inventor.

what I would like to know is if the format used for that approach the only format that inventor can use? I am trying to use ilogic to give my spreadsheet more freedom. Instead of the "Parameter Name, value, units" format which I find to be very limiting.

Is there a way to set up an excel spreadsheet similar to how my ipart table is displayed? so parameter names and column numbers rather than only having one column for variables as shown in my other photo.

I'm still trying to figure out how the strings for calling values etc work so forgive my ignorance. actively searching and have found these but haven't been successful in applying them:
http://ellipsis-autodesk.typepad.com/blog/2010/05/inventor-on-steroids-ilogic-excel.html
https://knowledge.autodesk.com/support/inventor-products/getting-started/caas/CloudHelp/cloudhelp/20...

Thanks! 🙂

[Xun.Zhang · Accepted solution]

---

@chrisjspower wrote:

what I would like to know is if the format used for that approach the only format that inventor can use?

---

Regard to this one, the answer is yes currently.

Regard to your original question to have the xls format more like ipart author, I have to say, there are two kind of things. Parameter xls more like adding new customized parameter to the parameter table and the format is more consistent with current parameter dialog which makes more sense to user.

However, iPart author just pick up useful parameter and even more other properties. So, the scenario is different. 

Hope it helps!

[chrisjspower]

This does make sense, I have managed to get my method to work but it is quite painstaking and not very reliable. I may be missing some snippets as it sometimes wipes the data from the xls cells but it uses a call and write to cells method which seems to work... mostly. I can have as many sheets as I like and write to any cell I like. Will probably have to build a template and workflow for it to be truly beneficial.