data in the gridview and expected data in excel

Question

1)the data such as sample message is being passed using the xml 

2) now the message falls in sql storage

3) now at log portal we fetch the data in gridview

 

4) we have expected data in excel sheet according to filter such as category.

 

5) unit test cases example on how to do it . actually wanted help in protractor c#

for grid  anugular js i.e ng grid used .  

6) create the automated unit cases regarding fetching data from grid and compare at excel

in excel , we have the test data prepared.