Skip to main content
12 events
when toggle format what by license comment
Nov 18, 2022 at 15:04 comment added Niels Abildgaard I don't think suggesting a paid product is a solution to this question.
Feb 11, 2022 at 15:31 history edited TylerH CC BY-SA 4.0
added 450 characters in body
Feb 10, 2022 at 20:05 history edited Michael Fayad CC BY-SA 4.0
update source code link
Jun 23, 2019 at 20:24 history edited jmbpiano CC BY-SA 4.0
Minor spelling and grammar corrections and removal of extraneous strike-through.
Feb 15, 2018 at 22:53 comment added Marc Meketon @Paul Chernoch: We populate large Excel sheets with interop very quickly. The secret is to do a bulk update. Create a object [,] block, populate that, then write that matrix to Excel at one time: excelWorksheet.get_Range(range).Value2 = block;
Sep 28, 2017 at 20:55 history edited Stadem CC BY-SA 3.0
Updated CodePlex reference to GitHub reference
Aug 12, 2015 at 16:10 comment added Chris Marisic For clarity in this thread, the LGPL allows the software to be linked to without the infective part of the GPL occuring. You only need to open source changes you make to ClosedXml or if you directly put the source code (as opposed to referencing the ClosedXml assemblies) inside of your application then you need to open source your application.
Feb 24, 2015 at 3:39 comment added PeterX @JanKällman You should update your CodePlex page to show you've got these methods available: LoadFromCollection<T>, LoadFromDataTable etc. (found via here)
Feb 10, 2015 at 18:55 comment added Paul Chernoch The examples were helpful. I was able to change my code from using Microsoft interop library (horribly slow) to this library (version 4.x) in a couple hours. My benchmark writes a file with two tabs and about 750,000 cells. Using MS interop it took 13 minutes. Using EPPlus it took 10 seconds, a roughly 80x speedup. Very happy!
Dec 16, 2013 at 23:37 history edited user2509901 CC BY-SA 3.0
deleted 1 characters in body
Dec 8, 2010 at 5:39 history made wiki Post Made Community Wiki
Mar 29, 2010 at 12:25 history answered Jan Källman CC BY-SA 2.5