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)

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

Split_Files_Using_LinQ

lrtetala (Lakshman Reddy) March 1, 2024, 5:36am 4

Try this

Regards,

1 Like

Topic		Replies	Views
Splitting an excel file into multiple excel files Activities excel , question	5	1545	April 7, 2023
Splitting one excel file to multiple excel files Studio	3	1176	May 5, 2021
Split excel files into multiple files Automation Hub	10	4352	March 5, 2021
How to Split Datatable and save in multiple excel files Studio studio , question , activities_panel	2	177	March 15, 2024
How to separate excel file if data have > 200 rows? Activities excel , activities , question	8	1257	August 7, 2021