Monday, May 30, 2011

Programmatically create excel


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