Excel - Write Value/Add Row questions
Is it now possible to use TestComplete's "Excel - Write Value" and "Excel - Add Row" to read/write multiple rows of info in Excel? I read the post that makes it possible to read/write in a single cell, but it doesn't take into account if you wanted to do the same for say, 10 ... 20 ... 50 cells.
I know that it is possible using JScript as I am currently using a script written by someone with more knowledge than I have, but I am a real novice when it comes to this stuff and was hoping for something a little more user friendly. Additionally, as I understand it, JScript is kinda being retired soon in favor of Javascript so I was hoping to get ahead of the game. Thanks.
Have a read through https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/index.html
If you want to work with ranges of cells, change cell formats, or work with cells containing formula expressions, then refer to https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/working-via-com.html - this is slightly more complicated!
Do try out the examples shown in the documentation, and you will get a better understanding of how it works.