Is there a way to create Excel relationships using ClosedXML? I tried to do it using a Dataset but it was not implemented in the Excel File.

Is there a way to create Excel relationships using ClosedXML? I tried to do it using a Dataset but it was not implemented in the Excel File. using (XLWorkbook wb = new XLWorkbook()) { ...

Id #9458 | Release: None | Updated: Wed at 1:27 AM by Code360 | Created: Wed at 12:36 AM by dannyso

How to remove autofilter?

How to remove autofilter from workbook when convert to excel?

Id #9457 | Release: None | Updated: Aug 13 at 6:04 AM by Narender_Dhull | Created: Aug 13 at 6:04 AM by Narender_Dhull

ClosedXML read row with VLOOKUP formula

im currently working on a project that reads data from excel but im having errors with my code because the excel cells have vlookup formulas in it. is there a way for xlosedxml to read row values w...

Id #9456 | Release: None | Updated: Aug 7 at 9:55 AM by flourin | Created: Aug 7 at 9:55 AM by flourin

Unable to open .xlsx from iPad

I have a strange behaviour when I try to open a ClosedXML file from iPad. A blank page is shown, with the message: filename.xlsx "Office Open XML Spreadsheet" file-size. If I choose to open it w...

Id #9455 | Release: None | Updated: Aug 5 at 3:06 PM by jeanie77 | Created: Aug 5 at 3:06 PM by jeanie77

ClosedXML does not preserve style

So this is my code using (var document = new XLWorkbook(root + outFolder + copied)) { var sheet = document.Worksheets.First(); var allRows = sheet.Rows(); ...

Id #9454 | Release: None | Updated: Aug 11 at 10:10 PM by gummz00 | Created: Jul 23 at 10:21 AM by gummz00

Hide does not hide Worksheet

Can someone explain why the code below does not actually hide the worksheet? workbook.Worksheet("Saber Tooth Audit Legend").Hide(); workbook.Worksheet("Saber Tooth Audit Legend").Visibil...

Id #9453 | Release: None | Updated: Jul 17 at 12:19 AM by marklane123 | Created: Jul 17 at 12:19 AM by marklane123

Apply subscript formatting to part of a string.

Is there a way to apply subscript formatting to part of a string in a cell when using ClosedXML? For example, I need a string similar to "valPEAK", where the "PEAK" would be subscripted. These stri...

Id #9452 | Release: None | Updated: Jul 15 at 3:34 PM by slockwood87 | Created: Jul 15 at 3:34 PM by slockwood87

COUNTIF allowed syntaxes

At the moment, the only way to successfully use the COUNTIF function seems to be the one using a syntax like COUNTIF(A1:A8,"=3") Where A1:A8 contains numbers. If the contents are strings, or if...

Id #9451 | Release: None | Updated: Jul 15 at 3:17 PM by RedGlow82 | Created: Jul 15 at 3:17 PM by RedGlow82

String/integer comparison

Excel accepts expressions like: IF(3="","a","b") Where the comparison obviously returns false. ClosedXML tries to convert the empty string to an integer, fails, and cause an exception. In attach...

Id #9450 | Release: None | Updated: Jul 15 at 2:24 PM by RedGlow82 | Created: Jul 15 at 2:24 PM by RedGlow82

COUNTA not skipping empty cells

The function COUNTA should count the number of non-empty cells in the given range: https://support.office.com/en-us/article/COUNTA-function-7dc98875-d5c1-46f1-9a82-53f3219e2509 The current implem...

Id #9449 | Release: None | Updated: Jul 15 at 1:07 PM by RedGlow82 | Created: Jul 15 at 1:07 PM by RedGlow82