Excel DDT using diff WorkSheets for diff testcases
Posted: Fri Jul 01, 2016 1:08 pm
Hi All,
I am in a situation where two(more) test cases needs different kinds of data and tried as below
1) Created excel sheets and bind one excel sheet with one test case. As soon as I bind second sheet with second test case, I lost binding with first spread sheet in first test case.
2) Then tried with one spread sheet using Data Range option, I am facing the below issue
By default first row considering as Data Column but in my case Data columns are different for different test cases. so its confusing while binding other test cases.
for example I have data columns(first row) for first test case as ------ AA BB CC -> it works fine for first test case.
For second test case data columns or variable heading are --- XX YY ZZ. When I am trying to binding, Data columns ( variable headings) are still showing as --- AA BB CC.
My Question is: When first option is not possible and second allows me using Data Range option, my expectation is like every first row in data range should act as a Data Column or Variable header.
ex:
First testcase --- Data range 1-7 -- means --- 1st row is a data column
Second testcase --- Data range 10-25 -- means --- 10th row is a data column
Third testcase --- Data range 30-50 -- means --- 30th row is a data column
It would be great if any one helps me to do so.
Thanks in advance
I am in a situation where two(more) test cases needs different kinds of data and tried as below
1) Created excel sheets and bind one excel sheet with one test case. As soon as I bind second sheet with second test case, I lost binding with first spread sheet in first test case.
2) Then tried with one spread sheet using Data Range option, I am facing the below issue
By default first row considering as Data Column but in my case Data columns are different for different test cases. so its confusing while binding other test cases.
for example I have data columns(first row) for first test case as ------ AA BB CC -> it works fine for first test case.
For second test case data columns or variable heading are --- XX YY ZZ. When I am trying to binding, Data columns ( variable headings) are still showing as --- AA BB CC.
My Question is: When first option is not possible and second allows me using Data Range option, my expectation is like every first row in data range should act as a Data Column or Variable header.
ex:
First testcase --- Data range 1-7 -- means --- 1st row is a data column
Second testcase --- Data range 10-25 -- means --- 10th row is a data column
Third testcase --- Data range 30-50 -- means --- 30th row is a data column
It would be great if any one helps me to do so.
Thanks in advance