Table Theme

Attached is an excel file with a custom Table Style. The loading of the table theme borks because enum.parse can't find a value. Recommend changing the theme to a string and using enum.tryparse. ...

Id #9499 | Release: None | Updated: Aug 18 at 12:04 PM by vbjay | Created: Aug 18 at 3:31 AM by vbjay

Error doing data validation from another sheet

When using closedxml to add data validation to a file, all validations are written in the <x:dataValidations> element. However, this is not how excel saves data validation from other sheets. Here...

Id #9498 | Release: None | Updated: Aug 11 at 7:10 PM by jesta1215 | Created: Aug 11 at 5:58 PM by jesta1215

Datetime is 1 day off

Greetings, I'm trying to write a datetime to a cell using ClosedXML. I set the IXLCell DataType to be XLCellValues.DateTime, and the value to be a new DateTime. I also set the number format id to...

Id #9497 | Release: None | Updated: Aug 3 at 8:55 PM by jesta1215 | Created: Jul 28 at 2:07 AM by jesta1215

Closed XML Formatting Issue

When I cloned a copy of excel I have cells with no formatting means it's just plain white cells without any borders. But once I save the excel using C# workbook.save() some weird lines appear ...

Id #9496 | Release: None | Updated: Aug 12 at 4:13 PM by tfletch | Created: Jul 24 at 12:37 PM by manojsethi

Store must be open for this operation

I am creating an excel file in excess of 40MB using the .net 4.5.1 framework with ClosedXML for .Net Framework 4.0. I save and reopen the file to append every 10000 rows to conserve memory. This ...

Id #9495 | Release: None | Updated: May 30 at 6:03 PM by LouLoglisci | Created: May 30 at 1:34 PM by LouLoglisci

Error While loading excel generated from reporting tool

Hi, I have generated one excel from reporting tool but while loading excel from below line is throwing exception. XLWorkbook Workbook = new XLWorkbook(excelFileName); {"Object reference not ...

Id #9494 | Release: None | Updated: Jun 15 at 2:46 PM by JIMMYCORZO | Created: May 16 at 10:51 AM by prat9899

Formula IFERROR not included

Hi, first of all: Thank you for the ClosedXML-API! I have a Worksheet with the formula "IFERROR(Auswertung!B113,""""), but I can't get the value. Is there a possibility to get the cell text with...

Id #9493 | Release: None | Updated: May 12 at 11:31 AM by Cionk | Created: May 12 at 11:31 AM by Cionk

ClosedXML integration with Windows RMS (Right Management Services)

ClosedXML integration with Windows RMS (Right Management Services) I got requirement to Export Excel with integrating the Windows AD RMS ( Active Directory Right management Service) integration. ...

Id #9492 | Release: None | Updated: May 4 at 2:47 PM by nicksoft | Created: May 4 at 2:47 PM by nicksoft

How to update/formatting existing excel (like template) file?

Please guide me for How to update/formatting existing excel (like template) file? I have tried below code but it's give error. // FilePath - c drive temp folder string tempFile = FilePath +...

Id #9491 | Release: None | Updated: May 2 at 11:16 AM by amitjoshiTTI | Created: May 2 at 11:15 AM by amitjoshiTTI

System out of memory(Hide row)

How to hide a row from 1000 to 1048576 it will show some error message like System out of memory

Id #9490 | Release: None | Updated: Apr 22 at 6:14 AM by Alavudeen_soft | Created: Apr 22 at 6:14 AM by Alavudeen_soft