Convert departments to sheets in uipath give the flow

lets assume we want to group by all rows by the departement and split it to different worksheets we can do

Grouping the data:


Assign Activity:
TableList | List(Of DataTable) =

(From d in dtData.AsEnumerable()
Group d By k=d("Department").toString.ToUpper.Trim
Select t=grp.CopyToDataTable).toList

For Each Activity | tbl in TableList | TypeArgument: DataTable

  • Write range Activity:
    SheetName = tbl.Rows(0)(“Department”).toString.Trim
1 Like