Get Exact column value from an excel

[Palaniyappan (Palaniyappan P)]

Hi

Hope the below expression would help you get the column name

For AA1, AA2, AA3,……

Same with a little change in expression

Convert.ToChar( (65 + dt.Columns.IndexOf("Columnname") ) - 26).ToString + (dt.Rows.IndexOf(CurrentRow)+2).ToString

(Output will be “AA1”, “AA2”,…. String type)

Refer this thread for complete details

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Cheers @karthikeyan.srinivasan9