Excel spreadsheets are one of the most popular forms to distribute, transfer, and report data records. The approaches of converting data to Excel with Office InterOp libraries and creating physical files are suitable for implementing server applications. The best scenario without the third-party tool for exporting data to Excel files for a more modern Object Oriented application.
This article will demonstrate the tasks by sending out emails with an Excel file attachment and downloading the Excel file from a data page.
Although this seems an old topic, processing using an Excel byte array from generic list with Open XML SDK are revitalizing this area.
Read the rest of the post here:Â http://www.codeproject.com/Articles/790013/Dynamically-Creating-Excel-File-from-a-Generic-Lis