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.
@Palaniyappan @arivu96 @ppr Do you guys have any idea .
For mapping int to Excel column name following is very helpfully
For Retrieving the Row and Col Index for the fist occurence of totalproductcost find starter help here:
DT_GetRowIdxColIdx_ByValue.xaml (8.7 KB)
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.
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.
@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 !!
Try to use LookUp Range
It will give You the Cell Position in which that word present.
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
@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
sure we will help you, just open a new topic for your case
I have opened my topic I will share the link
[this my link thankss] ( Have many files and saved into one file)
Tried this But got no luck