How to use group by for excel

[yigit.aybey (Kuki_Shinobu)]

Hi guys,

i need to use group by method in linq or if you have much better idea of course you can informed me. I want to group of Semt / Mahalle. Each Different data separating different sheets. It is not logical but just i need so.
Do you know how to i do that.

This is my excel

Can you explain step by step ;
ex : - read range columng0
assign linq or smt else

Thanks.

[Yoichi]

Hi,

Hope the following sample helps you.

dict = dt.AsEnumerable.GroupBy(Function(r) r("Semt / Mahalle").ToString).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable)

Sequence2.xaml (10.1 KB)

Regards,

[Gangadhar_Athili]

Simply You Can Write it As ;

DT.Asenumerable.Groupby(Function(r) r(“Col_Name”).Tostring).Select(Function(g) g.Copytodatatable).Toarray

Output : Array of Datatable

By Using For each…You Can get each Datatable and By using write range you can write it in a particular Excel File.