Strange FileNotFoundException

I've got a worksheet with half a million rows. After writing values to cells in the first 20 rows. I call Save() on the workbook. That produces the following exception: Could not find file 'C:...

Id #9365 | Release: None | Updated: Aug 29 at 3:54 PM by MDeLeon | Created: Aug 28 at 7:45 PM by nitewulf

bug with localized conditional formatting

I have encountered an issue with conditional formatting when my PC's region and language settings are set to something other than English (specifically, French or Italian). When I create my spreads...

Id #9361 | Release: None | Updated: Aug 14 at 5:19 PM by MDeLeon | Created: Aug 11 at 9:40 PM by TheonMartin

Table Corrupt File (Table in package starts at table2.xml)

When copying a template excel file to the new location and generating rows from data and then opening the file. I get this message: screenshots <?xml version="1.0" encoding="UTF-8" standalone="...

Id #9360 | Release: None | Updated: Aug 8 at 6:07 PM by vbjay | Created: Aug 8 at 5:32 PM by vbjay

trying to save data to a database

I'm trying to save data to a database; excel was generated with ClosedXML. The value of a cell through ClosedXML is not read. But I can not read a DataTable I want to generate for OleDb. I need...

Id #9352 | Release: None | Updated: Jul 29 at 2:10 PM by el_topo_48 | Created: Jul 29 at 2:10 PM by el_topo_48

ClosedXML_v0.73.0.0 (.net 3.5)-worksheet.Columns().AdjustToContents(1) does not work for headers

var workbook = new XLWorkbook(); var worksheet = workbook.Worksheets.Add(dt,"Sample Sheet"); worksheet.Columns().AdjustToContents(1); In case headers in first row are longer than values, this c...

Id #9351 | Release: None | Updated: Jul 29 at 12:26 PM by deimos1986 | Created: Jul 29 at 12:26 PM by deimos1986

How to Add Image In Header Using ClosedXML

Error At AddImage(imagePath,XLHFOccurrence.FirstPage); Error : The method or operation is not implemented. var workbook = new XLWorkbook(); var worksheet = workbook.Worksheets.Add("Covering ...

Id #9350 | Release: None | Updated: Jul 29 at 9:04 AM by metalrose | Created: Jul 28 at 8:04 AM by swapnilmalap

Saving after saved by libreOffice

If I open a xlsx file with LibreOffice, and save it, and then if I try to edit and save it by code using ClosedXML, it will give an error when saving.

Id #9347 | Release: None | Updated: Jul 17 at 3:07 AM by xnasorcerer | Created: Jul 17 at 3:07 AM by xnasorcerer

CustomFormat at Row

hi. When you save the Excel read that you specify font and fill in the entire worksheet, Font specification and fill the empty cell is disabled. sample code private static void Main(string[] a...

Id #9346 | Release: None | Updated: Jul 15 at 11:01 AM by daigoto | Created: Jul 15 at 11:01 AM by daigoto

Variable Datatype

I am using vb.net as my language and I am having a difficulty determining the correct datatype for some of the examples given, especially the variable for data with ranges. From what I am seeing is...

Id #9341 | Release: None | Updated: Jul 9 at 8:17 PM by MDeLeon | Created: Jul 3 at 2:32 PM by 2keicy7

Style.Font.FontColor incorrectly determined

Hi, In attachment a small excel file: the font color for cells C6, C7, C8, C9 is black (as can be verified by vba). However ClosedXML returns the color Silver for these cells. Code snippet: ...

Id #9340 | Release: None | Updated: Jul 2 at 8:02 PM by MDeLeon | Created: Jul 2 at 2:13 PM by RobbieDeSutter