how to have the details of different employees in different sub sheets of a excel .
Welcome to the UiPath community!
You need to elaborate more on your requirement.
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 .
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?
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:
Thank you i will try this , if it works for me or not .