Get Column Index Number

[Pramod_Bharat_Mangale]

Hello Friends,

I have Column M1 or Say M, I need “13” as number for it, can anyone help how can I get this.

Thanks in Advance

[Gokul001 (Gokul Balaji)]

Hi @Pramod_Bharat_Mangale

Try this expression

Dt.AsEnumerable().Where(Function(w) w.ItemArray.Contains("13")).Select(Function(s) Dt.Rows.IndexOf(s)).First()

DT.Columns.IndexOf(“ColumnName”).ToString

If possible can you share the sample Input and expected output

Regards
Gokul

[ashwin.ashok ((TheCodingTheory))]

Hi @Pramod_Bharat_Mangale ,

Do you want to rename the column from text to number?

Kind Regards,
Ashwin A.K

[Pramod_Bharat_Mangale]

Yes, You Correct

[ashwin.ashok ((TheCodingTheory))]

Then could you try this?

dt.Columns(ColumnNameOrIndex).ColumnName = "13"

Kind Regards,
Ashwin A.K

[Sudharsan_Ka]

HI @Pramod_Bharat_Mangale

Try this

Uipath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex(“M”)

Hope this Helps

Regards
Sudharsan

[ppr (Peter Preuss)]

 UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("M")
 13
 UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(13)
 "M"
 UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("AA")
 27
 UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(27)
 "AA"

[Sudharsan_Ka]

@Pramod_Bharat_Mangale If you have like M1 try this

Uipath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex(System.Text.RegularExpressions.Regex.Match(“M1”,“\D+”).ToString)

Regards
Sudharsan