Forum Discussion

Nikolayev's avatar
Nikolayev
Contributor
3 years ago

How to check the values in an EXEL FILE opened during the test

Hello,  I have to do a test wich is opening an Exel File. Then when the file is open during the tests, I have to do check point of the name of the COLUMN wich are  : Nom Fichier - Id Emetteur - Per...
Nikolayev's avatar
Nikolayev
Contributor
3 years ago

Thank you for you're answer Marsha_R

Can you tell me more please

I have done a test with datadriven Loop and  I have this : 

It is not what I am exepected

 

I should have "The table checkpoint "Nom Fichier" passed"  or something with "Nom Fichier"

  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    3 years ago

    I need to see your excel sheet and your data driven loop please.

    • Nikolayev's avatar
      Nikolayev
      Contributor
      3 years ago

      Here it is Marsha_R : 

       

      Nom FichierId Emetteur Periode

       Numero URSSAF/SNV2

      		Date Creation
      \\SrvIdisQalFile01\idis\IDISWork\A0146_OB_IRCEM_354_161038.TXTA060001S63201703T54700000AAA213376720/12/2017
      \\SrvIdisQalFile01\idis\IDISWork\A0146_OB_IRCEM_354_161038.TXTA060001S63201703T54700000AAA213376720/12/2017

      Etc......