The row highlighted in yellow will not be always in fixed row in this excel sheet.
Our requirement is to delete all the rows above highlighted row.
Hi @Sathish_Kumar_S ,
Follow this below steps,
-
First Lookup for “User” value in excel as shown in below screenshot and get the address of the value.
-
Next use Insert/DeleteRows activity as shown below,
CInt(System.Text.RegularExpressions.Regex.Match(valueAddress,"[0-9]+").Value)-1
Hope this may help you
5 Likes
This will delete all the rows above the look up value?
Hi @Sathish_Kumar_S ,
Yes, Can you run for your input file and let us know?
Alternative Method:
- Use excel scope, within this use
LookUp Range
activity to look for that value - This activity returns the cell value
- Now use
Delete Range
activity to delete the respective range from an excel
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.