Split data in excel

How to split data in excel into multiple worksheets

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

https://intellipaat.com/community/11626/splitting-an-excel-sheet-into-multiple-sheets-using-ui-path

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

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