Skip to main content

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

Comments

Popular posts from this blog

How to accept outlook meeting invite via keyboard shortcut ?

  There are two ways you can accept a meeting request. 1. when you are browsing list mail (and invite isn't opened) 2. wen you have opened the invite

Tips 'n' Tricks : SVN : Visual Studio Plugin : AnkhSvn

Now we can access SVN from Visual Studio :) ,

Tips 'n' Tricks : SVN : ignore-on-commit

By using this predefined list , we can group the files which we want to ignore while committing changes. This way our local changes related to only local deployment doesn’t get check [automatically] in with all files . We have choice to include them by selecting the check box