I am having a requirement where i need to read the worksheet name eg. if sheet1 is hello1. then i need to pick sheet1 get the name hello1 and then validate further scenarios accordingly. Can we do it in winrunner?
If you have any influence in the contents of the spreadsheet, I suggest you ask that the sheets be named "sheet1," sheet2," etc (or whatever you choose), and that the "name" be placed in an additional column in the sheet. That way, with the help of CSO functions you can choose "sheet1" or "sheet2" etc, then get the name you need from the data in that sheet.