Split_Files_Using_LinQ

Help Activities
, ,
1

Hi Expert,
I have an Excel file with 1319 line items. I need to split multiple files with 200 line items each with the same header. How can achieve this by LINQ. Attached input file for your reference.

Regards,
Balachander
Split_Input.xlsx (43.4 KB)

2

@Balachander_Pandian

Do you want split total line items into mutiple datatables having 200 line items each

dt.AsEnumerable().Chunk(200).Select(Function(a) a.CopyToDataTable()).ToList()

gives output as list of datatables

3

Hi @Balachander_Pandian

Try this:

dt.AsEnumerable.Chunk(200).Select(Function(a) a.CopyToDataTable).ToList

image
image792×910 45.1 KB

BlankProcess20.zip (128.1 KB)

Regards

4

Hi @Balachander_Pandian

Try this

Regards,

1 Like
5

@Balachander_Pandian

Getting FirstDate and LastDate of Year.zip (2.4 KB)

Output:
SplitExcel.xlsx (41.5 KB)

image
image507×705 28.6 KB

6

@Balachander_Pandian

PFB workflow for your reference

BlankProcess20.zip (238.3 KB)

Output:

image
image960×324 4.54 KB

Regards,

1 Like
7

Hi @Balachander_Pandian

image
image620×717 31 KB

Output Excel

Split_Input.xlsx (74.6 KB)

1 Like
8

Hi @Balachander_Pandian

Check the below zip file

BlankProcess20.zip (128.1 KB)

Hope this meets your requirement

Regards

1 Like
9

Hi @Balachander_Pandian

image
image620×717 31 KB

Output with different sheets
Split_Input.xlsx (74.6 KB)

Hope it helps!!

1 Like
10

Hi @vrdabberu Thank you so much …It works well.

11

Hi @Balachander_Pandian

If the solution works for you, please mark my post as solution to help other members.

Happy Automation!!

12

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