Actually i am exporting a excel sheet from an application,but the excel sheet should be like this.......
Global | |
| | _______|_______|_______________________________
Test |Value |Data
23 | 34 | 56 _______|_______|_______________________________
In the above EXcel Table(Assume) My column names(Headers) are - Test , Value , Data .But "Global" is the additional one....I want to remove the entire "Global" row in runtime.....Is it possible by any way????...( If i remove the "Global" Column then the headers comes up then i can do my job very eazy.....)
If you look at the function ddt_get_parameters() and execute it against the table, you will see that the parameters you receive back are "Global","B","C". When a specific column is not defined with a parameter, WinRunner takes the default Excel naming of the column.
You can do one of three things.
1) use the param list that is pulled back from the ddt_get_parameters() function and then just skip row #1 (the row that has the columns defined as you want), or
2) write a routine that will take the default ddt_get_parameters() information, skipping row #1, and create a new file writing rows #2 - ddt_get_rowcount()'s return and then reference this new sheet with the parameters you defined, or
3) Just use variables to remap the column headers as pulled back from ddt_get_parameters() and skip row #1, then you are referencing what ever is pulled back from the sheet as you expect to read the information