Forum Discussion

surajgr's avatar
surajgr
Occasional Contributor
13 years ago

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 ...
SmartBear_Suppo's avatar
SmartBear_Suppo
Icon for Alumni rankAlumni
13 years ago
I don't think there's a way to do that in the same test case. The problem is there with excel too. For example, try:
- open a CSV file in Excel and keep it open
- open the same file in Notepad and try to change it and save it

You'll see that the first instance of Excel will hold the lock on it to prevent changes.

I'd try, if possible, to break the steps out into different test cases and execute the test suite.

Michael Giller
SmartBear Software