Topic: ClosedXml

[Jeff H]

I remember MexicanCustard suggesting a API for dealing with excel a couple of times so I did a search and dug it which was ClosedXml and glad he did because I probably would of used OpenXml but this API is easy, quick and useful.

Thanks again MexicanCustard a very useful library.

[Keith Brown]

http://spreadsheetlight.com/ is also very good.

[MexicanCustard]

  NP.

[jhsct]

Try Gembox Software.  http://www.gemboxsoftware.com/spreadsheet/overview

It's the best I've used.

[Keith Brown]

Try Gembox Software.  http://www.gemboxsoftware.com/spreadsheet/overview

It's the best I've used.

That one is not free.  The two mentioned above do not cost anything and have most features that I will need.

[Chumplybum]

i've used EPPlus before for reading / writing excel files with .net, http://epplus.codeplex.com/

[Keith Brown]

XLSIO is now free if you download the Syncfusion Community Edition which is free for small companies and individual users.


https://www.syncfusion.com/products/communitylicense

[MexicanCustard]

XLSIO is now free if you download the Syncfusion Community Edition which is free for small companies and individual users.


https://www.syncfusion.com/products/communitylicense

Yeah, with Syncfusion going the free route I'm going to try their version. I'm also going to try switching from iTextSharp to Syncfusion's PDF version too.

[CADbloke]

I'm about to put together a project which has a fair bit of Excel stuff so I've been looking into this, so far Epplus looks like the front-runner. As much as I'd like to try the Syncfusion tool I really like having the source code for the library available so I can see what it is doing and fix and issues I find (and submit them back, of course). Epplus also supports Linq, which is nice.

If you're using Epplus, http://www.paragon-inc.com/resources/blogs-posts/easy_excel_interaction_pt8 has a couple of interesting gotchyas. There other posts in that series are pretty good too.

I'll let you know how I go...