Plan is to share different ways to export data to excel . I will be writing this topic in installments.
There are many ways to create an Excel file/ export data to excel. I will list down few , later will post samples of each and then will try dig little more and share the pros and cons of them. Let us see how far I go in this ...
1. Create csv file and open in excel
2. Use oledb to create excel
3. Use office inerop / vsto
4. Use office open xml