Split data in excel

Learn Academy Feedback
1

How to split data in excel into multiple worksheets

2

Hi @Ganesh_A, welcome to UiPath community! Please refer to the following links:

3

Hi, Thank you for the response.
I need to split data by row count and the row count is dynamic

4

Hi ,

Can you try by

  1. dataTable.AsEnumerable.Take(5)
  2. Skip the 5 and take next 5 for From next worksheets until the Total Number of rows reached