Forum Discussion

Sandyapitester's avatar
Sandyapitester
Frequent Contributor
9 years ago

how to solve JXL error : jxl.read.biff.BiffException: Unable to recognize OLE stream

Hi All,

 

Have written the groovy script for data driven for while execution am getting error message as 

  java.io.FileNotFoundException: C:\XXXX\XXX\.XXXX\XXXX\Testdata.xls (The system cannot find the file specified) error at line: 4

 

have shared the screen shot for the reference

 

Please let me know how to fix the issue

 

  • KarelHusa's avatar
    KarelHusa
    Champion Level 2

    If you post the Groovy code we might be able to help.

     

    The windows paths are a bit tricky, I assume it will be the issue.

     

    • Sandyapitester's avatar
      Sandyapitester
      Frequent Contributor

      Hi Bro

       

      Thanks for the update it's working now because have used POI jar file

       

      it's supporting all the file format

       

       

      Am facing a new issue now

       

      Open source need to transfer the response value in the property but the problem is 

       

      response having

      {

      username:XYX

      Firstname:ABX

      Lastname:ZZZ

      }

      {

      username:zya

      Firstname:fff

      Lastname:xxx

      }

       

      {

      username:qqq

      Firstname:ooo

      Lastname:oooo

      }

       

      here need to pass only XYX value in my property and oooo too

       

      if u know the solution help me to fix it