Excel Data searching Problem

Help Activities
, ,
1

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??

2

Hi,
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)
3

Hi @Athul_AK

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.

Thanks.