@Bhupesh_Gupta - I’m a bit confused on the pay slip portion. There are 3 payslips with different info in each. How did this get populated? The info is different for each payslip. How do you know the first one is tied to Pankaj?
As for the Sample Salary document, it’s a very poorly created excel document. Even the columns are split into multiple rows, so you cant easily read a datatable from it properly. I would suggest using a read range for the range C9:K1000 (or some other row number that will exceed the most you’ll ever get). Then use the column index to get the data you want. This is heavily reliant on the excel document NOT changing. It is extremely fragile and not something I would feel confident in automating personally. However, if the excel document doesn’t change in structure at all, you can just remove all rows where C is blank, then loop using for each row and get the necessary data by using row.item(0).tostring, row.item(1).tostring, and row.item(8).tostring