In my data table i have the following type of data.
Now I want to sort data of the data table with ID’s(1,2,3) and should store data(entire row) that equal to ID 1 in one excel sheet and same where ID matches 2 should store in second excel same follows with the ID 3. Please note that i want to sort based on 3 ID’s only.
Can any one suggest a way to search data in datatable and writing the while row to the excel sheet. That equal to the particular ID(1 or 2 or 3).
Thanks and Regards,