Best .NET library or tool to create Microsoft Excel files

I am trying to find the best tool (commercial or open source) to generate Excel files (XLS or XLSX).

Of course, I could easily create files in CSV format.
However, my clients are financial people that much rather have native Excel files.

Your experience (positive of negative) with such a tool is appreciated.

Craig Johnston, Aug 28, 2013

Reply 1

Hi,

The .NET Library for excel which i use after reading good and positive response from users is Aspose.Cells for .NET. It has been a year and a half that i am using this Library and so far i haven't got any problem and their support team is very good. It allows you to create, read, edit, and convert excel file to many other formats. It is not free but offers free trial so you can try this Library if you haven't found any good library for excel.

Regards,

Jameson Vaughn

Jameson Vaughn, Feb 26, 2014

I agree on your first part. But I have some disagreement with 2nd viz. For abstract factory...I think the carpenter would still be the one making doors...but for installing a door, only a door is not enough...you need hinges, knobs, handles, stoppers, nails etc. So we would have a NailFactory, KnobFactory, HandleFactory etc. to make a complete door. So the abstract factory would be solely responsible for making complete doors with the help of NailFactory, HandleFactory etc.

Jun 27, 2017

Two question if you can answer: 1 . Factory design pattern gives one object.. Abstract Factory gives you factories .. What if we need multiple products of one type.. like 5 plastic doors.. would we be making abstract factory in this case?

Apr 17, 2017

juz wow.. what a simple explanation... i also signed up just to say thanks to you :) keep it up

Apr 17, 2017

Easy to understand :)

Nov 17, 2016

I created an account solely for the purpose of thanking you for those perfect analogies. So thank you :)

Jun 05, 2012