How to divide data in excel into diff sheet by spliting them equally

Help Studio
, , ,
1

suppose i have a data of 10000 i want to divide the data into 4 sheets say ex1,ex2,ex3,ex4 in 2.5K in each sheet and mates give any any suggestions and if sequence well and good.

Sample_file.xlsx (134.9 KB)

2

Hi @LOHITH_KUMAR_SAKA

Please try this

DT.AsEnumerable.Chunk(250).Select(Function(a) a.CopyToDataTable).ToList

image
image900×910 45.1 KB

Sequence.xaml (9.3 KB)

Output:

Sample_file.xlsx (175 KB)

Regards,

3

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