Search data from excel

[SanMan]

Hi,

I have a working data connection to excel file in my test.

Now I need to search that excel sheet. I have a string value in test and need to find in which column it locates in the excel sheet.

How to make that search?

[krstcs]

You cannot use the Ranorex data connectors for searching through data sheets (or tables in a DB). The data connectors are intended to be used only for feeding test data into your test. In other words, your spreadsheet should contain the data that you are using to run the test.


If you need to validate that the UI you are testing contains a certain value that changes based on the test run, you could use the data connector to connect to the source data and validate in your test that the UI matches the source.

[Ciege]

You can do this by referencing the Excel Interop in your code, then opening and searching through the required spreadsheet(s) yourself.

Through the Excel COM interface you can read and write spreadsheet data however you wish.