Exporting huge DataSet or DataTable into Excel via byte array

CodePatternAdSense

You can do it using third party well written code that are available in the form of API. But you need to remember one very important point while handling large amount of data. If your DataTable is having more records then you have to choose specific version.

MS Excel can have up to 65536 records/rows per sheet except Office 2007 and higher versions (in MS Office 2007 and after this version, there is no limit virtually). Also if you want to implement it without any API then you have to write all the code yourself by handling issues.

You can refer this Microsoft help document on the same issue but using API -
http://msdn.microsoft.com/en-us/library/bb739834.aspx