Best pratice . Compare Data grid with xls file

Question

I have a data grid that I fill with data from an excel file.

What is the average way to compare the grid of data and the values of the excel file in testcomplete ?

Can I create an object matching my excel data and compare it with an object from my grid?

The position of the columns of my grid is not fixed, I can't use namemappinng for target my cell.

How to do ?

Regards,

PV

shankar_r · Answer

So, You want to compare the AUT Grid values with Excel sheet values.&nbsp;Can you provide some sample data and share what actually you want to verify?&nbsp;

tcdp · Answer

Hi,&nbsp;&nbsp;&nbsp;In attachement, you will find an exemple.&nbsp;In&nbsp;the first testCase , I fill the data Grid.&nbsp;&nbsp;Now I would like to compare the values ​​of my grid with the xls&nbsp;file to verify that the insertion has worked well.&nbsp;Thanks&nbsp;

tcdp · Answer

Example&nbsp;https://wetransfer.com/downloads/bcf13c4393d47b908d36fd1a1ccc936720170322114026/f8bc28aa453e12c8ca6d96444b22caab20170322114026/456fcf

Forum Discussion

Best pratice . Compare Data grid with xls file

3 Replies

Related Content

Comparing table data in IF not working

How to compare images?

compare object

How to compare web content

Compare logos on pages

Recent Discussions

convert absolute path to relative path

Multiple execution of a test plan with different values from an Excel table

Searching for mapped object took too much time msg

mht files are by default opening in Edge browser and its blank

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License