using (XLWorkbook wb = new XLWorkbook())
wb.Worksheets.Add(dt, "BPA Supplier Report");
Id #9477 | Release:
| Updated: Tue at 1:39 PM by Abilash | Created: Tue at 1:39 PM by Abilash
We have created a service using ClosedXML version 0.76. The feature it includes is to upload and download data in excel. The user is allowed to update minimum data, therefore the sheet is...
Id #9476 | Release:
| Updated: Mon at 12:41 PM by geeta_chugh | Created: Mon at 12:34 PM by geeta_chugh
I ran across an issue that took me several hours to narrow down what was actually happening, since it seemed very random. However, once I simplified my code, I finally found how to re-pro...
Id #9475 | Release:
| Updated: Jan 31 at 7:47 PM by zpert | Created: Jan 31 at 7:47 PM by zpert
I am trying to read excel and convert it to DataTable but getting error in first statement itself
var workbook = new XLWorkbook(filePath);
var stream = File.Open(filePath, FileMode.Open,...
Id #9474 | Release:
| Updated: Jan 13 at 6:36 PM by mishraom | Created: Jan 13 at 6:36 PM by mishraom
TFS deployment run to error:
ASPNETCOMPILER: Type 'DocumentFormat.OpenXml.OpenXmlElement' is a recursive collection data contract which is not supported. Consider modifying the definition of coll...
Id #9473 | Release:
| Updated: Jan 6 at 6:34 PM by hansdu | Created: Jan 6 at 6:33 PM by hansdu
I understand that working with DrawingsPart isn't supported, but it would be very useful in my situation to have that part copied when I use CopyTo to duplicate a worksheet. As it stands now, the n...
Id #9472 | Release:
| Updated: Dec 18, 2015 at 6:17 PM by jhood | Created: Dec 18, 2015 at 6:15 PM by jhood
When i try release my project, the error is in spanish and say
__Advertencia 1 La referencia principal "ClosedXML" no se pudo resolver porque se generó con la versión de .NET Framework ".NETFr...
Id #9471 | Release:
| Updated: Jan 8 at 10:31 AM by vittoso | Created: Dec 18, 2015 at 4:26 PM by gogomix
I am creating an excel file. I cannot seem to get more than 100,000 rows total per workbook before getting an out memory exception. I have turned tracking off.
What do I need to supply to help yo...
Id #9470 | Release:
| Updated: Dec 22, 2015 at 5:08 PM by aknittel | Created: Dec 17, 2015 at 6:15 PM by aknittel
If you run this code, everything will be OK.
var book = new XLWorkbook();
var ws = book.AddWorksheet("ws");
ws.Cell("A1").Value = 2;
ws.Cell("B1").Value = 3;
ws.Cell("C1").FormulaA1 = "PROD...
Id #9469 | Release:
| Updated: Dec 17, 2015 at 1:26 AM by p_s_malkov | Created: Dec 17, 2015 at 1:21 AM by p_s_malkov
I'm trying to read a .xlsm file and its not opening. I have search a bit and found that probably ClosedXML doesn't read .xlsm files, and this is available here on codeplex ( https://closedxml....
Id #9468 | Release:
| Updated: Dec 14, 2015 at 5:24 PM by pfmartins | Created: Dec 14, 2015 at 5:13 PM by pfmartins