Hi Team, I want to search for an item in Excel and if that item is found in Excel then I want to extract a particular range of row data from Excel. if Is there any activity available for this? or can any one help on this??
there’s no single activity for this. You’ll have to implement this as a multistep approach, for example:
- Use the Find activity within Excel to find the item you’re looking for
- Check if the Find activity has results
- If so, use the read range activity in Excel (you’ll need to parametrize the range though, from what I understand)
You could use Vlookup Data table, which can be used if you read the entire file into a datatable.
Also, to workdirectly on Excel you could use Find/Replace activity in excel.