Can't set header on non empty header

I am using this code to set the header on a document that already contains headers(first page and odd even) and it does not work. pageSetup.Header.Center.AddText("first", XLHFOccurrence.FirstPage...

Id #9500 | Release: None | Updated: Sep 21 at 12:48 PM by shenhavba | Created: Sep 21 at 12:48 PM by shenhavba

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: Sep 6 at 1:44 AM 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: Sep 20 at 4:05 AM by kumarkolli | 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: Sep 15 at 4:52 PM by igitur | 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