Interacting with excel files in C# windows application

Question

I have a windows application where I've to create an excel document with formatted columns (only schema) and then read the same files when use has added data from outside ? What i could be best approach out of the below : 1. Microsoft.Office.Interop.Excel 2. OLEDB connection 3. Open XML

Bhushan Gawale · Answer

As you said its going to be a windows application and if you have office clients installed on your machine as well as on your target workstations then I think using interop makes more sense and its fairly straight-forward approach compared to other mentioned two.

Sandip Darade · Answer

You are right Bhushan but the other reason behind preferring OpenXML is that my technical architect wants it . :)

Bhushan Gawale · Answer

Right but only if you dont manage to dispose COM objects properly If you follow standard practices - then I think wont be an issue for you.

Sandip Darade · Answer

Well my apparent assumtion is that Interop hampers the performance in some way.

Bhushan Gawale · Answer

any specific reason why you are trying to avoid COM components?

Sandip Darade · Answer

Thanks Bhushan I was thinking I could avoid dealing with COM by not using Interop .

shi lianghong · Answer

You can try this API for .NET . They have free edition.