I am trying to generate my test reports in an external Excel File. I want to put
a) Sheet1 contains the summary of all Iterations like in
Total Iteration: 10
Iteration1 : Pass
Iteration2 : Fail
Iteration3 : Pass
and so on. And when user clicks in the cell which contain iteration number "Iteration1", then it should open the respective worksheet. So the first sheet(Sheet1) should have hyperlinks to all other sheets.
Since Excel file by default have three sheets, so i want to rename
Sheet2 to Iteration1
Sheet3 to Iteration2
and after that i want to add a new sheet for each successive iteration.
To put it in simple words, i want to
start with Sheet1, then want to make a decision whether a blank sheet exist.
if yes, select the blank sheet and rename that to Iteration[i]
if no, add a blank sheet and rename that to Iteration[i]
where i will go from 2 to Environment.value("TestIteration")
Thanks a lot. Since i am using QTP 9.1, i am not sure if its there. One guy in other team is using QTP 8.2 and i searched there too but could not find it. So can you tell me what keyword should i use to search Excel Code examples in QTP help. And these examples are available in QTP online help or some other document.