How to update Excel in a ranorex iteration
Posted: Fri Feb 07, 2014 2:01 pm
Is it possible to update an excel document in a ranorex iteration?
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.