Creating seperate excel based on dates

DT.Asenumerable.Groupby(Function(r) Tuple.Create(r(“value”),r(“year”))).Select(Function(g) g.copytodatatable).Toarray

Output : Array of Datatables

Take For each (Properties : Argument type : Data table)

Inside for each take write range