Hi!
I need to create a performance log while running qtp tests, and I want to write the results out to an excel sheet.
Now, there does not seem to be an obvious way to create a row in excel. Even more so, using datatable.nextRow will jump to the freaking first row, and what makes it even worse is that if I used a pre-prepared sheet with dummy values in it, "lastRow" will take me to the last row of those dummy values (obviously), so before each write to the excel I would need to actually search for the first entry which is a dummy value, before I could write to the sheet.
Can somebody please help me out!? (Or if there is no way of adding a row let me know the adress of the guy who designed that freaking qtp object model?)
Thanks alot!
Cheers,
CC
I need to create a performance log while running qtp tests, and I want to write the results out to an excel sheet.
Now, there does not seem to be an obvious way to create a row in excel. Even more so, using datatable.nextRow will jump to the freaking first row, and what makes it even worse is that if I used a pre-prepared sheet with dummy values in it, "lastRow" will take me to the last row of those dummy values (obviously), so before each write to the excel I would need to actually search for the first entry which is a dummy value, before I could write to the sheet.
Can somebody please help me out!? (Or if there is no way of adding a row let me know the adress of the guy who designed that freaking qtp object model?)
Thanks alot!
Cheers,
CC