TheSwamp

Code Red => .NET => Topic started by: Jeff H on January 05, 2015, 01:43:28 PM

Title: ClosedXml
Post by: Jeff H on January 05, 2015, 01:43:28 PM

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 (https://closedxml.codeplex.com/) 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.

Title: Re: ClosedXml
Post by: Keith Brown on January 05, 2015, 01:46:15 PM

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

Title: Re: ClosedXml
Post by: MexicanCustard on January 05, 2015, 04:07:41 PM

 :wink: NP.

Title: Re: ClosedXml
Post by: jhsct on January 05, 2015, 05:22:39 PM

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

It's the best I've used.

Title: Re: ClosedXml
Post by: Keith Brown on January 05, 2015, 05:43:22 PM

Quote from: jhsct on January 05, 2015, 05:22:39 PM

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.

Title: Re: ClosedXml
Post by: Chumplybum on January 05, 2015, 05:52:12 PM

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

Title: Re: ClosedXml
Post by: Keith Brown on January 09, 2015, 01:34:09 PM

XLSIO (https://www.syncfusion.com/products/file-formats/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 (https://www.syncfusion.com/products/communitylicense)

Title: Re: ClosedXml
Post by: MexicanCustard on January 12, 2015, 08:33:06 AM

Quote from: Keith Brown on January 09, 2015, 01:34:09 PM

XLSIO (https://www.syncfusion.com/products/file-formats/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 (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.

Title: Re: ClosedXml
Post by: CADbloke on April 06, 2015, 06:42:30 PM

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