Forum Discussion

Nikolayev's avatar
Nikolayev
Contributor
2 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

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
Champion Level 3
2 years ago

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

  • Nikolayev's avatar
    Nikolayev
    Contributor
    2 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......