Plz solovemy issues

[katta_nikhil]

i have an excel file… and i have a string on “AJ” coloums
i want that coloumns index nummber how can i find that index number
New Microsoft Excel Worksheet.xlsx (8.6 KB)

[vishal.kp (vishal)]

Hi @katta_nikhil ,

You can refer to the balareva easy excel custom package by @balupad14 :

It has find activity which provides the index after finding the given text.

BalaReva Easy Excel Activities - RPA Component | UiPath Marketplace

Regards,

[katta_nikhil]

is there any other approach to find the index number for that particular coloumn

[balupad14 (Balamurugan)]

HI @vishal.kp ,

Take a look at these.

UiPath Go ! BalaReva EasyExcel Activities

Hi, A situation to find and replace the text inside the Excel. For that purpose, I have developed some activities below. Find - Find the text inside the sheet. It will return the cell info as an array string and row indexes. FindReplace - Find and replace the text inside the Excel sheet. [image] [image] Regards Balamurugan.S

Uipath Excel Find | Search | Find and Replace (BalaReva)

Regards
Balamurugan.S

[supermanPunch (Arpan)]

@katta_nikhil

i have an excel file… and i have a string on “AJ” coloums

Hi @katta_nikhil ,

Here, the condition is not properly shown or provided to us.

Do you want to search for the column name ? or a value in any of the columns and you would want to know to which column it belongs ?

If it is the column name that you are trying to find and then get it’s column Index, maybe you could check the below :

DT1.Columns.IndexOf(DT1.Columns("nikhil"))

Now, If the string is value in one of the columns, then we can use the below Expression :

DT1.AsEnumerable.Select(Function(x)Array.IndexOf(x.ItemArray,"nikhil")).SkipWhile(Function(x)x=-1).First

[katta_nikhil]

iam not able to install this dependency

[Anil_G (Anil Gorthi)]

@katta_nikhil

You can first use find/replace activity which would give you the cell name of excel then we can convert it to index using below expression

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToIndex(VarCellName)

You can extract column name using the cell address output

System.Text.regularExpressions.regex.Match(celladdress,"[A-Z]+").Value

You can pass any column name of excel like AF and it would give the index of it

Cheers

[Gokul_Jayakumar (Gokul Jai)]

Hello @katta_nikhil
Refer to this xaml file you may get some idea.
ForumColumnIndex.zip (148.1 KB)
Step

1. Use Excel application scope and indiacte the file path
2. Use the Lookup range in it and get output as a string of its position in Excel like “AJ1” store in variable Position.
3. Use regex to separate the column Name

Position= System.Text.RegularExpressions.Regex.Match(Position,"\D+").ToString.Trim   ----> AJ

4. Use the UiPath Excel expression to convert the alphabet to the index number.

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex(Position)    ----->36

[kiran.t (Kiran thulasi)]

Hi Nikhil,

Here we go i have attached sample workflow…

Column INdex.zip (8.6 KB)