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
A Lot To Learn, Explore and Share...