Hello, I want to read excel header but the position is not constant. [MicrosoftTeams-image (2)] Here header is in 3rd row i used “Lookup range” activity to get the headers but the problem is that iam using a write cell activity. how would i get the index corresponds to that header. [MicrosoftTe…

@Gokul_Murali Then after looks up first use read range and then dt.Columns.Count will give you the count of columns which can be used as your column value UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(dt.Columns.Count+1) this gives the last column excel name to use in your …

Excel Header Reading

Help Studio

lrtetala (Lakshman Reddy) July 17, 2023, 9:16am 4

Hi @Gokul_Murali

Try like this

I hope it helps!!

Topic		Replies	Views
How to Read Datatable in Excel Activities excel , studio , question	10	747	October 17, 2023
Dynamically get the Range of Column Headers Activities excel , activities , question	5	110	June 27, 2024
Excel Write Cell Activities excel , activities , question	5	548	September 30, 2023
Read range by header name StudioX studiox , question	7	782	April 28, 2023
Need to help to replace column headers in Excel Activities datatable , excel , activities , studio , question	9	823	November 10, 2023

Excel Header Reading

Related topics