Multiple DataSink Steps to Same Excel File But Diff Sheets
Hi all,
One of my test cases contain 3 datasink test steps. I want each of these steps to write out data into the same Excel file but different worsheets.
I thought the solution was obvious - Set "File" and "Out File" fields to the same Excel file path for all 3 datasinks but specify 3 different worksheets in the "Worksheet" field.
But what happens when run the test case is that, the first datasink writes the data to the first sheet, second datasink removes data in the first sheet and writes data into the second sheet and finally, the third one removes data in the first two sheets and writes its own data to the third worksheet.
The only data that is really retained, arethe headers I added to the file PRIOR to executing the test case.
So currently I am maintaining three seperate Excel files, one for each datasink.
Is this the only solution or is there someway to make each datasink write out data into seperate sheets without removing any existing data, written out by prior datasinks?
One of my test cases contain 3 datasink test steps. I want each of these steps to write out data into the same Excel file but different worsheets.
I thought the solution was obvious - Set "File" and "Out File" fields to the same Excel file path for all 3 datasinks but specify 3 different worksheets in the "Worksheet" field.
But what happens when run the test case is that, the first datasink writes the data to the first sheet, second datasink removes data in the first sheet and writes data into the second sheet and finally, the third one removes data in the first two sheets and writes its own data to the third worksheet.
The only data that is really retained, arethe headers I added to the file PRIOR to executing the test case.
So currently I am maintaining three seperate Excel files, one for each datasink.
Is this the only solution or is there someway to make each datasink write out data into seperate sheets without removing any existing data, written out by prior datasinks?
