Page 1 of 1

Data Driven using excel

Posted: Thu Nov 06, 2014 7:41 pm
by rawatankit6
We are in a process of using MS excel sheets in order to data drive our test cases. I found the Ranorex excel connector very useful but their usefulness is limited as we cannot update the excel simultaneously. Can you tell me the way with which we can use excel COM object to open, edit or manipulate excel in our Testcases.

Re: Data Driven using excel

Posted: Thu Nov 06, 2014 8:30 pm
by krstcs
First, there are numerous threads on the forums that discuss this issue already, which you can search for and read. For example: http://www.ranorex.com/forum/updating-e ... t4820.html

However, it is not recommended and can cause other issues if you are not very careful.

Second, if you are updating your test seed data during the test, you might reconsider why you are needing to do that. Usually you don't really need to and probably shouldn't do it anyway.

If this is because you are using complex data sets and need to manipulate what data is returned (not the data itself) during the run, you should probably use a real DB (SQL Server Express is free) instead of a spreadsheet. This will allow you to create SQL queries that can return exactly what you are looking for.