Data Driven using excel

Ranorex Spy, Recorder, and Studio.
rawatankit6
Posts: 11
Joined: Thu Aug 21, 2014 7:50 pm

Data Driven using excel

Post by rawatankit6 » Thu Nov 06, 2014 7:41 pm

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.

krstcs
Ranorex Guru
Posts: 2683
Joined: Tue Feb 07, 2012 4:14 pm
Location: Austin, Texas, USA

Re: Data Driven using excel

Post by krstcs » Thu Nov 06, 2014 8:30 pm

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.
Shortcuts usually aren't...