Split large xls into multiple 1000 line files in c#

  I need to load and split a large xls file into smaller ones for processing.

Can anyone show me how to do this?
Who is Participating?
SriVaddadiConnect With a Mentor Commented:
You could use Excel Interop.

1. Create an instance of Excel Application
2. Load the file
3. Read a range of values and write into another workbook or worksheet as you might want. Save each of the excel workbook.

Check this link


Please feel free to write back if need be
jetbetAuthor Commented:
Thanks for the quick response
All Courses

From novice to tech pro — start learning today.