Ranorex Forum

Hi there,

I have a datatable created by opening a Db connection and retrieving data from a table, I now want to compare data within datatable with data in excel (this is my data source) and write out differences into another worksheet in the same excel. Can you please help me acheive this? I need solution asap.

Alternatively, is there a way to compare data from datatable generated by databaseSqlconnector with data in excel and write differences into worksheet?

Thanks in advance.
Pari

Hi,

There is no built-in way to achieve what you want. You will have to code something up.

I would suggest you to start with these samples:
http://www.ranorex.com/support/user-gui ... html#c7787
http://www.ranorex.com/support/user-gui ... html#c7781
You will have to adapt either of these samples to work with Excel/DB data connector. You can find many code examples of working with Excel data connectors around this forum. Just try to search them.