Skip to main content

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

By

 

xlsx

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
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

2

EPPPlus / Office Open XML

http://epplus.codeplex.com/

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

3

CSV

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.

4

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

Labels:

Comments

Post a Comment

Thanks :)
-Baljeetsingh

Popular posts from this blog

How to accept outlook meeting invite via keyboard shortcut ?

By
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

Post a Comment
Click Here Read More ...

Learning Angular With Baljeet : Day 01

By
I would be posting a series on learning angular js

I would be posting small todos, if you follow along you should be able t

To Beging with

1. you need to install Node.JS (https://nodejs.org/en/)
2. Node.js would get you npm also
3. Download WebStorm as Editor
4. Download Angular CLI command npm install -g @angular/cli)
5. Create new angular app (command d:\RnD\Angular\> ng new HelloAngular
7. open your newly created project in browser by command ng serve --open

one pending todo here is overview of the angular project basic terminolgies
app --> module --> component
every component would have --> .ts , .css, .htmls , .spec file

- Baljeetsingh
Post a Comment
Click Here Read More ...

Microsoft .NET Framework 3.0 (Brief Overview)

By
Topics:
What is the Microsoft .NET Framework 3.0?
What is Windows Communication Foundation ?
What is Windows Presentation Foundation ?
What is Windows Workflow Foundation?
What is Windows Card Space ?


What is the Microsoft .NET Framework 3.0?
The Microsoft .NET Framework 3.0 (formerly WinFX), is the new managed code programming model for Windows.
1 comment
Click Here Read More ...