Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel Find Column Function

2 REPLIES 2
Reply
Message 1 of 3
johnster100
352 Views, 2 Replies

Excel Find Column Function

Hi there,

I have some ilogic code for writing to excel. I use the findrow function (GoExcel.FindRow) and this works well.

 

I would like a similar function for finding a column with specific name, like a find column function. I would like this as my spreadsheet may change in the future and the columns may be moved, so I am loathed to use the fixed excel names (A, B, C, D etc).

 

Any help would be appreciated,

thanks,

John

Tags (2)
2 REPLIES 2
Message 2 of 3
ZacRocket
in reply to: johnster100

I know this thread is very old. Were you able to ever find an answer?

Message 3 of 3
ZacRocket
in reply to: johnster100

By the way i found out you can use GoExcel.FindColumn("Column Header") but be sure to open the right file to the right sheet first

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report