Find position of a cell

[Shikhar_Tandon]

Hi Robosapiens,

Stuck on a part of work needed some urgent help.
Any leads would be highly appreciated.
My Problem statement is :
For example :

Suppose there is a excel sheet with data starting from say A7 , so the headers are on the line A7 the headers can be ex. cost, unit,item,totalproductcost

I want the cell value of column name “totalproductcost”
for example i used :-

Convert.tochar(65+Dt.columns.indexof(“totalproductcost”)) this would give me the poistion of cell like E or F but i want the exact cell position of column totalproductcost, as here can be seen is “E7”

Any leads would be appreciated.
feel free to ask me anything.

Thanks !!
@Palaniyappan @arivu96 @ppr Do you guys have any idea .

[ppr (Peter)]

@Shikhar_Tandon
For mapping int to Excel column name following is very helpfully

Excel Index to Column - RPA Component | UiPath Marketplace

For Retrieving the Row and Col Index for the fist occurence of totalproductcost find starter help here:
DT_GetRowIdxColIdx_ByValue.xaml (8.7 KB)

[balupad14 (Balamurugan)]

Hi @Shikhar_Tandon ,

Here is the activity called “Find”. It has the output as Cell Info and rowindex. Like E7 as Cell Info and 7 as row index.

UiPath Go ! BalaReva EasyExcel Activities

Hi , One my friend @VanessaCova having the 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 a array string and row indexes. FindReplace - Find and replace the text inside the excel sheet. [image] [image] Regards Balamurugan.S

Regards
Balamurugan.S

[Shikhar_Tandon]

@ppr Got this xaml , but it giving output as in terms of row number and column number , i want is the cell number like i told E7 for totalproductcost, not getting it on how to get this. Can you please help .

Also when i am using read range and searching this column “totalproductcost” from excel it is giving ‘Not Found’ always.

Thankyou !! for your efforts !!

[ImPratham45 (Prathamesh Patil)]

Try to use LookUp Range
It will give You the Cell Position in which that word present.

[arifudinmyf]

Have many files and saved into one file

abc.xlsx (7.9 KB) data.xlsx (8.5 KB) def.xlsx (7.9 KB) ghi.xlsx (7.9 KB) I have excel files “abc, def, ghi” each of which has data in a sheet, and I want to move it to a file “data” where in the “data” there is a sheet whose name is also sheet “abc , def, ghi” I ask that you please help me thanks.

help me

[ppr (Peter)]

@Shikhar_Tandon
Yes it is correct. starter help is returning indexes on Datatable base.
But in the post and also in demo comments a description is given on how to map to an EXCEL range:

• Using the workflow from the Connect Platform (see post above) to map integer to excel column letter.
• adding 1 to overcome 0 based Index to 1 based index

However @balupad14 gave a hint that the same task can be done within the EasyExcel Activities. So I would suggest to first check, if it will work for you or not

[ppr (Peter)]

sure we will help you, just open a new topic for your case

[arifudinmyf]

I have opened my topic I will share the link
[this my link thankss] (Have many files and saved into one file)

[Shikhar_Tandon]

Tried this But got no luck
Worried !!

[AhmetALTIN]

thank you very much