Split large xls into multiple 1000 line files in c#

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

Can anyone show me how to do this?
jetbetAsked:
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

http://msdn.microsoft.com/en-us/library/ms173186(VS.80).aspx

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

From novice to tech pro — start learning today.