How to Split Datatable and save in multiple excel files

Hi, i need to create multiple excel files using a datatable. I have a excel which is having 1000 row count, so need to split it 100 rows per each file. Please guide me.

Hi @srinivasanma1

Condition in If
dt.AsEnumerable.Chunk(100).Select(Function(a) a.CopyToDataTable).ToList

Check the below xaml file.
Main.xaml (11.7 KB)

If possible share your input excel. I will help you with flow.

Regards

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.