Studio - How to get the dynamic Column from Excel

I’m in Studio.
Here’s the screenshot of the spreadsheet. I would like to calculate the total quantity (column B) and write the sum to the immediate next empty cell i.e. cell B7
I’m doing the following - Read Range, assign counter as 0, for each row in DT counter = counter+row(“Qty”). I’m getting the correct sum.
I want to know how to get the column name i.e. the Qty is in Column B. How to get ‘B’ ? The DT.Columns.IndexOf(“Qty”) will give 1 but I need ‘B’. How do I get it ?

Hi @Prinal_C

Use this code to find the column name

Convert.ToChar(65+DT.columns.IndexOf(“Qty”))

Regards,

Nived N

Happy Automation

3 Likes

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