Get last column of Excel sheet in Alphanumeric form

Help
,
9

hey @Als,
I figured out what was wrong with my solution. I have added it to @aksh1yadav 's example, so you can check that one out if you’d like also.
Excel_Column_Name_mapping.xaml (8.5 KB)

If you have trouble getting the column number correct, you could do an indexOf of your datatable maybe?
For example,
dt1.Columns.IndexOf(“columnname”)+1

Thanks.

3 Likes