readin the excel with read range - dtData
Variable: TableList - DataType: List (Of DataTable)
Assign Activity:
TableList =
(From d in dtData.AsEnumerable
Group d by k=d("Year").toString.Trim into grp=Group
Select t=grp.CopyToDataTable).toList
So the TableList holds all split datatable
E.g. with a for each loop over TableList you can write out Excel when this is also needed