Classic PivotTable Layout Not Working

Hi, I am trying to get my pivot tables to display in the classic pivot table layout. Here is my code snippet.. System.Data.DataTable tbl_records = db.GetReportRecords(sheet.SheetQuery); ...

Id #9504 | Release: None | Updated: Dec 22, 2016 at 6:35 PM by pgmills79 | Created: Dec 22, 2016 at 6:35 PM by pgmills79

An item with the same key has already been added

Hi, I am getting this error while trying to process same excel workbook (.xlsx) file more than once. this error comes while initialization only. using (XLWorkbook workBook = new XLWorkbook(ex...

Id #9503 | Release: None | Updated: Dec 22, 2016 at 10:38 AM by vaibhav_tajane | Created: Dec 22, 2016 at 10:38 AM by vaibhav_tajane

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: Nov 11, 2016 at 10:00 AM by igitur | Created: Aug 11, 2016 at 6:58 PM by jesta1215

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: Sep 27, 2016 at 11:03 AM by igitur | Created: May 30, 2016 at 2:34 PM by LouLoglisci

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, 2016 at 12:31 PM by Cionk | Created: May 12, 2016 at 12:31 PM 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, 2016 at 3:47 PM by nicksoft | Created: May 4, 2016 at 3: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: Sep 27, 2016 at 1:57 PM by igitur | Created: May 2, 2016 at 12:15 PM 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, 2016 at 7:14 AM by Alavudeen_soft | Created: Apr 22, 2016 at 7: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: Oct 13, 2016 at 4:00 AM by NickNack2020 | Created: Apr 20, 2016 at 3: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, 2016 at 5:04 PM by Flominator | Created: Apr 13, 2016 at 4:58 PM by Flominator