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
How to compare datatable and excel
Re: How to compare datatable and excel
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.
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.
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
Ranorex explorer at Descartes Systems
Please add these details to your questions:
- Ranorex Snapshot. Learn how to create one >here<
- Ranorex xPath of problematic element(s)
- Ranorex version
- OS version
- HW configuration