Open the excel file go to cell A1 (using send hot key ctrl+g and type into provide the reference as A1), after that again you can send hot keys as ctrl+f and the find the text S.TL. once you found the text you can click on to the name box and get the value using get text… this will give the value I10 then you can use read range and provide the range in between the value you got how many rows you want to extract… → extracted result will be the data table and you can write the data table directly to the csv
using read range activity read the sheet → Range mention as “B10”-> check add headers then you will get the datatable.
from that datatable you can get the “S.TL” Column alone so we can write it into separate sheet.
I am trying to get position’s information of cell have title “S.TL” by message box like below.
Now I can only find value text cell by each row and get no. of column (But not correct, first cell show to me message box is “column5”).
If we have correct no. of column, how to change to name such as “I10” or get no. of row or name of column.
This my file is testing. TestFindPosition.xaml (14.2 KB)
Please help to check.
instead of finding cell you can get the the all data to datatable and you can write into another sheet what column you want it right.
i hope this is the easiest way. no need to open excel sheet and finding the position
yes exactly correct,
i said try to read from the excel to datatable from there try to get row and column value.
And also he know only search text alone but don’t know about end position so i suggested like read as datatable then check for the column name and write that column alone in superate sheet.
Use “Excel LookUp Range” The result will be the cell address of what you are searching for. So, in the “Lookup Range” activity, you’d enter the name of the sheet, and the range of cells to search. The value to search for would be “S.TL” and in your example above, the result returned would be “I10”