Creating seperate excel based on dates

[sruthesanju (Sweety)]

In Excel i have the data as

Value. Year
123. 2022
123. 2022
123. 2021
123. 2021

Above data will be in single Excel i need to update based on year and value in seperate Excel.

So,. 123. 2022
123. 2022 in seperate Excel

And 123 2021
123 2021. In update in seperate excel

[ppr (Peter Preuss)]

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

[sruthesanju (Sweety)]

Need to include 123 also ,if it’s 123 and it has year need to split

[ppr (Peter Preuss)]

pleas show us sample output as statement is doing this already as mentioned in the req

@sruthesanju

So,. 123. 2022
123. 2022 in seperate Excel

And 123 2021
123 2021. In update in seperate excel

[sruthesanju (Sweety)]

After splitting using list how to update in seperate Excel

[ppr (Peter Preuss)]

like following:
for each activity setting TypeArgument is set to DataTable

You will just adapt the logic of the sheet name e.g when using the Year we can do

item.Rows(0)(“Year”).toString.Trim

[sruthesanju (Sweety)]

Ia m getting empty list

[ppr (Peter Preuss)]

@sruthesanju

Ia m getting empty list

It looks more that the Visual representation of the list shows us a result of 2 Datatables where the table name is not set

we dont know what was done / implemented. So give more details when you need more help once you debugged and traced the flow

Also you can check in the immediate panel e.g. TableList.First()
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

[sruthesanju (Sweety)]

In raw view i am getting two datatables how to update in Excel

[ppr (Peter Preuss)]

we can write back into excel as shown above

[sruthesanju (Sweety)]

Can you explain the highlighted part in yellow

[ppr (Peter Preuss)]

what value you want to set for the different worksheet names?

[sruthesanju (Sweety)]

Need in different excel not in different sheet

[ppr (Peter Preuss)]

then just do it similar to

and assign the file path dynamical to the excel scope

[Gangadhar_Athili]

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