Want to call the common excel from project specific automation.
It should work like below,
- Have common method for Excel read & write. Excel read: To find the test case ID. Excel write to write the status like"pass" or “Fail”.
- Assign dynamic variable for Path of the excel, sheet and range for the above “Excel read and write”.
- Invoke the dynamic variable value from the another method called “Main” or “Project specific”
- If test result pass, it should write the status of pass or fail in the particular excel sheet.
It could be helpful if anyone helps on invoking the datatable from one method to another.