Downloaded Excel File Verification

TestProject Addons, SDK and Coded Tests
#1

I have a scenario, where i download a file from the application and verify the contents in it.
I am able to get the downloaded file name with full path. But i am unable to do the verification. Below are the actions i tried to verify the contents, but everything is giving error:

  1. Read File - Gives FileNotFound exception
  2. Get Data From Excel - Gives NullPointerException
  3. Read Column Values from Excel - Gives NullPointerException
  4. Read Row Values from Excel - Gives NullPointerException
  5. Search data from Excel - Gives NullPointerException
  6. Search text in Excel - Gives NullPointerException

Kindly help me on the same

#2

Hi @sandeep.m,
We are aware that there is an issue with the community addon Excel Operations, and we working to resolve this, we have a ticket open on it TP-16768, I will let you know once it’s resolved.

#3

Hi @Amit.Lacher

Thanks for your response. Would be waiting to hear from you once this is resolved.

#4

Hi @Amit.Lacher
Any update on this

#5

Hi @sandeep.m,
We have released an official addon, Excel Operations you should be able to find it on the library:

image

Let me know if that fixes your issue.