I have excel whose output is dynamic, how to find out the column position? i want to use it in Read Range, Range input.
Welcome to Community!
Could you elaborate your Query by giving Input and Expected output Screenshots?
Regards
I have output here in “E” Column, next output will be in “H” column and it is dynamic every output, i want to find the column position whether it’s E or H…
Sorry, i can’t able to attach excel sheet, as it says new user cannot attach excel sheet
Use the below expression to find the last column position!
Convert.tochar(64+Dt.columns.Count).toString
Regards
2 Likes
thank you very much.
Apology for asking! you have marked your reply as solution, please mark solution to my reply.
Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.