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
How to Separate the Unique and Multiple Line in the Column2 Using LINQ Activities excel , activities , question , linq	6	735	February 13, 2023
Split Excel / CSV File Size Help excel , activities , question	2	1031	December 24, 2020
Split excel/csv file Help	3	1284	August 24, 2020
How can I split Excel Data into multiple workbooks/files based on rows in Excel? Activities excel , activities , question	7	1330	October 29, 2022
Consolidated_LineItems_LINQ Activities excel , activities , question	3	42	September 6, 2024