I want to group by data rows from data table and print those rows in different Excel with the name of group by values.
below steps need to perform..
1. Main table is data table and it contains some rows.
2. i want to group by rows using department column. In that case i can get 3 different groups such that E-101,E102,E103 will be formed.
3. After grouping those values, i want to print and store in different Excel files in the name of E-101.xls, E-102.xls, E-103.xls,etc..
4. The sample output has highlighted in the image (==> E-101.xls, E-102.xls, E-103.xls )
4. How to do this in C#.