Our application is like that,
User logged into an application where he has involved in many departments. By selecting the departments, it will display my client page where user can see many clients. The number of clients will list in table format. (Client Table has following fields: ID, Name, Address, and Phone Number.
I have a requirement to test where I have to get set of values from web table based on selection of department, store it in excel format
Secondly, I have to compare value with that each set of value with expected data sheet with in same department code.
What I did so far, I had made parameterized the department code, so user can select any department code. I am having problem to get value from web table for each row and column, and paste to the excel sheet. And also compare to two value using excel.
Please help me how to set up for this.
I will be appreciating regarding this issue.