Extract Unique Values from Semi or Unstructured Excel

Tasks

• Identify the keywords whose value needs to be extracted.
• Use Excel advance package.
• Use the Find command to search the Keyword.
• The list variable will be generated and which in turn can be evaluated to read the value of the keyword.

This bot uses the “find” command from the Excel advanced package.
The user must pass a unique keyword that he/she wishes to search for and then extract the value of it.
The find command will search the keyword and gives output in list variables.
The value of a unique keyword can be evaluated by the list index.