Split the data

[Raina_Ocean_Sanjay (ocean Raina)]

how to have the details of different employees in different sub sheets of a excel .

[kumar.varun2 (Varun Kumar)]

Hi @Raina_Ocean_Sanjay

Welcome to the UiPath community!

You need to elaborate more on your requirement.

[Raina_Ocean_Sanjay (ocean Raina)]

i want to split the data of employees with an excel sheets , so that i that i can get the details of different employees in different sheets .

[william.coulson (Will Coulson)]

Hi @Raina_Ocean_Sanjay,

Welcome to the UiPath community! I would recommend you take a look at the following link, writing a more informative post will help people help you Forum FAQ - Beginner’s guide

Do you have any example data you are trying to split? And/or an example of the expected output?

[Raina_Ocean_Sanjay (ocean Raina)]

hi @william.coulson ,
i want to split this data as employee id in different sheets.
Employee_Data (1).xlsx (10.6 KB)

[william.coulson (Will Coulson)]

Hi @Raina_Ocean_Sanjay,

You can try using a Read Range to get your data in a DataTable, and then get a For Each Row to iterate through your DataTable.

In the For Each Row, you will want to clone the original DataTable to a new table. You can then add the current row in the For Each Row to the new table, and write the new table to another sheet within your file. The code should look something like this:

[Raina_Ocean_Sanjay (ocean Raina)]

@william.coulson
Thank you i will try this , if it works for me or not .