How to compare single coloumns in two excel sheets ans set value of cell as matched or unmatched

  • 72 Views
  • Last Post 24 September 2018
  • Topic Is Solved
varunkurup2@gmail.com posted this 23 September 2018

I tried to make a program where I am comparing two excel spreadsheets and based upon it set value in the second value as matched or unmatched . I am able to compare the two and I have used a VB script to loop through the excel coloumns to set value.but while setting value I am getting the error . Error thrown by the target of an invocation.I am attaching the flow below

ShivaKumar posted this 24 September 2018

Hi Varun,

 

Thank you for writing to us.  We do not see the process flow attached here. However, we have created a sample automation to showcase how Intellibot can be used to compare two excel files and project matched and unmatched output.

Please find mentioned below a link for the automation, click on the link to download the automation files and resources.

https://drive.google.com/file/d/1PjObmHmNE123vryaRXkS33ticaQ6WuAz/view

Hope we were able to answer your question and feel free to revert for any further clarifications.

 

Thanks,

Shiva Kumar,

 

Support Engineer.

Close