How to Copy one excel file data to another excel file with different sheet name



i have one excel file(expense1) in which 30 data is there.Now i want to copy data from “expense1” file into another excel file(expense2) in such a way that each sheet of “expense2” file contains 10 per sheet. like sheet1 will contains 10 data, sheet2 will contains 10 data, sheet3 will contains 10 data of expense2 file from expense1 file. How to achieve this using loop?

Divide Excel sheet

@Rahul_Raj, Implement this while logic after reading your excel expense 1.


For your reference : In write range I have written dt.AsEnumerable().Skip(nSkip).Take(nTake).CopyToDatatable()

nTake is the number of rows based on which you split into different sheet here its 10.

Dominic :slight_smile:

Split Excel based on row data rows