Community
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
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