How to update Excel in a ranorex iteration

Ranorex Spy, Recorder, and Studio.
Felmel
Posts: 7
Joined: Mon Nov 18, 2013 8:13 am

How to update Excel in a ranorex iteration

Post by Felmel » Fri Feb 07, 2014 2:01 pm

Is it possible to update an excel document in a ranorex iteration?

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

Re: How to update Excel in a ranorex iteration

Post by krstcs » Fri Feb 07, 2014 2:33 pm

First, there are numerous threads on the forums that discuss this issue already, which you can search for and read. 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...