Dim Cancellation_02_Row As TActiveDataRow
Dim Cancellation_02_ActiveData As TActiveData
Set Cancellation_02_ActiveData = LoadActiveData("Cancellation_02")
Dim Driver_Row As TActiveDataRow
Dim Driver_ActiveData As TActiveData
Set Driver_ActiveData = LoadActiveData("Driver")
For Each Driver_Row In Driver_ActiveData
For Each Cancellation_02_Row In Cancellation_02_ActiveData
If Cancellation_02_Row.GetString("ExpectedResult") = Cancellation_02_Row.GetString("ActualResult") Then
MsgBox " Successful "
MsgBox "TestCase Failed"
Driver_Row.SetString "NetResult", "FAIL"
Refer to this : "Driver_Row.SetString("NetResult", "PASS")" When I try to write data to Driver sheet, I am getting an error that Driver sheet is ReadOnly. How can I write into multiple datasheets in one script?
When you have created an active data asset, check with the Options tab, to unselect Force read only.
If your second question is to work with multiple worksheets of the excel file, then you have to create different active data for each worksheet.
You might also need to implement this code
Driver_Row.SetString "NetResult", "PASS"
Ya I have made sure that I unchecked the option "Force Read only" at the time of creation of the Active Data.
Creating more than one activedata for the same sheet also wont solve this problem I suppose coz the name doesnt matter here. Its just that I am not able to write into another sheet when I am inside a for loop iterating through another sheet. Can this be resolved by any chance?
Wat I want to achieve is whichever sheet am reading the data currently, I should be able to write the results into some other sheet which is the main driver sheet.