As planned and promised here is send post of export to excel series…..
# | Method / Technology | Pros | Cons |
1 | OLEDB | 1. Simple as Writing SQL queries | 1. Length of title can only be up to 64 characters |
2 | EPPPlus / Office Open XML | 1. Open source / GPLv2 | 1.does not support xls format i.e. File created via this will not work in |
3 | CSV | 1. Simple as writing text | 1. Cannot create multiple sheets |
4 | VSTO / Office.Interop | 1. Complete programming support to Excel Via C# | 1. Requires Interop DLL on server , this is shipped with MS office |
Comments
Post a Comment
Thanks :)
-Baljeetsingh