Skip to main content

Pros ‘n’ Cons of Different Technologies / Methods for Export to Excel



As planned and promised here is send post of export to excel series…..



Method / Technology





1. Simple as Writing SQL queries
2. Free
3. Supports XLS (JET OLEDB 4.0) and XLSX ( ACE 12.0)
4. Can Create Multiple Sheets

1. Length of title can only be up to 64 characters
2. To insert title as first row need extra columns also to maintain the structure
3. Does not support any styling / formatting of data
4. Cannot delete sheet with OLEDB
5. Sum how JET OLEDB does not work on our servers


EPPPlus / Office Open XML

1. Open source / GPLv2
2. Supports insertion of Rows and columns just as done in excel by mouse
3. support margin of cells
4. supports styles / lookups / Data (Cell) Format etc. ( have not tried extensively)
5. Can Create Multiple Sheets

1.does not support xls format i.e. File created via this will not work in



1. Simple as writing text

1. Cannot create multiple sheets
2. Cannot control styles / format
3. Writing / formatting row by row, cell by cell can take more time.


VSTO / Office.Interop

1. Complete programming support to Excel Via C#
2. Huge documentation / support available
3. Integrated support to Visual studio

1. Requires Interop DLL on server , this is shipped with MS office
2. Yet to explore


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