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: Thu at 2:07 AM by jesta1215 | Created: Thu 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: Jul 24 at 12:37 PM by manojsethi | 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

'', hexadecimal value 0x1A, is an invalid character.

When trying to write a datatable in .net to an Excel file with someout put from a third party I get an error message as per the subject line. '', hexadecimal value 0x1A, is an invalid character...

Id #9489 | Release: None | Updated: Apr 20 at 2:17 PM by SimonPrice33 | Created: Apr 20 at 2:17 PM by SimonPrice33

Umlauts in hyperlinks to files have wrong encoding

Trying to add hyperlinks pointing to a file on a network share containing umlauts in the path (e.g. "X:\Pläne\list.xlsx") - yes, I know what should be done to people creating these folders ;) I ...

Id #9488 | Release: None | Updated: Apr 13 at 4:04 PM by Flominator | Created: Apr 13 at 3:58 PM by Flominator