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

[lrtetala (Lakshman Reddy)]

Hi @LOHITH_KUMAR_SAKA

Please try this

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

Sequence.xaml (9.3 KB)

Output:

Sample_file.xlsx (175 KB)

Regards,