You can read/write Excel files with Apache POI or JExcelApi Java libraries.
Below are few examples.
Apache POI writing spreadsheet example:
I sadly have to break with the rest and recommend ranorex for actual record and playback. Selenium is fickle and needs a solid framework around it to produce solid tests. The selenium IDE can't provide that because it doesn't know the needs of your application.
Of course ranorex doesn't either but it's much more robust out of the box (which in my opinion ...
Selenium IDE for web (open source) and testcomplete for commercial(paid version)
Appium desktop for mobiles. You can tap and verify whether its working.
Inspector for desktop
Provided you are working on Selenium/Appium
Selenium IDE is best record and playback tool for web applications. The new Selenium IDE has many useful feature that makes the tool unique from all the other tools. Here is the blog which explains about the new features and it benefits. Kindly go through it.
To test web applications and record it you can use the most used Selenium IDE. It is very easy to learn and documentation is also very precise. You just need to download the extension and than it's all set.
You can start a new project by providing base URL. Afterwards you can multiple test under that project. The Selenium IDE records user's actions and than ...
I could not open your link.
Coincidentally, I came across a test case recently.
Normally, you should be able to choose which folder you want to download your file to. It is better for you to dynamically create such a folder so that no manual intervention is needed once your test is deployed. Doing so should solve this problem for different users.
We operate Enterprise Tester. A test management tool that is used by global organsiations as a replacement for QA Director. We offer the ability to migrate all your data (requirements, tests, executions and bugs plus the relationships) across to Enterprise Tester.
You can check us out at www.catchsoftware.com if you'd like to or drop me a line directly.
If your program flow is something like:
Upload changed spreadsheet
Then I suggest that you prepare a spreadsheet with the changes that you are testing for. Then your test can:
Verify that the spreadsheet download is happening
Upload the second spreadsheet
Verify that the relevant changes happen in the application