Forum Discussion

syanamala's avatar
syanamala
New Contributor
6 years ago
Solved

Comparison in Excel sheet : Test complete

I have to compare the  Excel cells data of one excel with the other.

But when opening it manually it is gving #CALC in cells data and automating through Test complete it is giving #NUM in cells data . Please let me know how to proceed.

 

Windows OS version : 10 X 64 bit

Office version : 2016

 

Thanks in advance.

Regards,

Srikanth

 

  • syanamala's avatar
    syanamala
    6 years ago

    Thanks tristaanogre ..Your'e right ..i have made changes in the excel settings and it worked fine.,

    and Again thanks for ur timely help..

     

    Regards,

    SYanamala

2 Replies

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor

    We would need to have a copy, potentially, of the Excel sheet that you're using and the code you're attempting to execute.

     

    My guess is that the excel sheet has formulas in the cells.  I think (but I'm not certain) that there is some setting somewhere in Excel that automatically resolves formulas.  This needs to be set so that the cells are resolved properly.

     

    Of course, it depends upon how you are interacting with the spreadsheet.  Again, your code would be a big help in understanding this.

    • syanamala's avatar
      syanamala
      New Contributor

      Thanks tristaanogre ..Your'e right ..i have made changes in the excel settings and it worked fine.,

      and Again thanks for ur timely help..

       

      Regards,

      SYanamala