Hi guha,

In Excel workbook the second sheet is active. so, when you extracted it took second sheet name. In for loop, you are passing the same name to "_WorksheetProxy1". so, it is going to node condition and datagridview2. that's the reason you are getting same results. one more thing the sheet count is 4. but for loop is executing three times. because the for loop is designed less than than count. in this case less than 4. that is 3. that's why you are not getting fourth grid in result. correct this one also.

Please revert back if you need any further clarifications on this.

Thanks,

Vasu