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:


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