Get Exact column value from an excel

[karthikeyan.srinivasan9]

Hi,

I want to get the exact column value, say for example if I give 1 its A, if 5 its E and if 26 its Z but if I go for 27 the it should return AA, if 30 it should be AD. Can you help me with this?

[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

[ppr (Peter Preuss)]

@Palaniyappan

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)

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(27)
will return AA