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

Related Content

Comparing table data in IF not working

How to compare images?

compare object

Compare logos on pages

How to compare web content

Recent Discussions

How can I retrieve the text of that dropdown below?

Is there a way to fail the test by matching 2 strings?

Looking to pass values from Execution Plan set up

Testcomplete is not minimizing while running userforms with RectObjectPicker

Making a URL semi-agnostic Page object in Keyword Test