How to find column position, if the position is dynamic with every output

Help Activities
, ,
1

I have excel whose output is dynamic, how to find out the column position? i want to use it in Read Range, Range input.

2

Hi @sudeep_kumar

Welcome to Community!

Could you elaborate your Query by giving Input and Expected output Screenshots?

Regards

3

image
image1366×768 93.3 KB

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

4

Hi @sudeep_kumar

Use the below expression to find the last column position!

Convert.tochar(64+Dt.columns.Count).toString

Regards

2 Likes
5

thank you very much.

6

@sudeep_kumar

Apology for asking! you have marked your reply as solution, please mark solution to my reply.

Regards

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.