Add iPart Column?

[santiagodiaz]

Is there a way to add an iPart column to the iPartTableColumns collection?
I'm using Inventor 2009.

[santiagodiaz]

Another question, can I assign an expression to an iPartTableCell?

It seems like I can't, the API will only support value, not expression. Can someone please confirm this?
If this were so, then is there a way I can access the excel spreadsheet that powers the iPart?
By accessing the excel file, I'm assuming that I could do a whole lot more. Edited by: SantiagoDiaz on Nov 22, 2009 4:50 PM

[johnnr]

Is it possible now?

[xiaodong_liang]

Hi,

the iPart table links to an Excel file. Here is the first blog of series of iPart table I am writing:

http://adndevblog.typepad.com/manufacturing/2013/02/manipulate-rows-and-columns-of-ipart-1.html

[johnnr]

That's cool.

I use copy and delete to add/delete rows. But I haven't figured out how to add/delete columns without the excel 12.0 object library.

Thanks

[xiaodong_liang]

Hi,

you can delete the row/column byiPartTableRow.Delete or iPartTableColumn.Delete without Excel. But you have to use Excel lib to add  row/column