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.