Best pratice . Compare Data grid with xls file

[TCDP]

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]

So, You want to compare the AUT Grid values with Excel sheet values.

Can you provide some sample data and share what actually you want to verify?

[TCDP]

Hi, 

In attachement, you will find an exemple.

In the first testCase , I fill the data Grid.

Now I would like to compare the values ​​of my grid with the xls file to verify that the insertion has worked well.

Thanks

[TCDP]

Example

https://wetransfer.com/downloads/bcf13c4393d47b908d36fd1a1ccc936720170322114026/f8bc28aa453e12c8ca6d...