Saving a xlsx with conditional formatting that a gradient with colors picked from the Theme Color selection throws an exception "cannot convert theme color to Color".
Changing said colors to one f...
Id #9385 | Release:
| Updated: Wed at 12:04 PM by Meoiswa | Created: Tue at 7:47 PM by Meoiswa
Failed to create a very large file
When I have more than 100000 rows gives me the following error
Row = 183 706 - System.OutOfMemoryException: An unhandled exception of type 'System.OutOfMemo...
Id #9384 | Release:
| Updated: Tue at 3:23 PM by lesta | Created: Mon at 12:17 AM by el_topo_48
I am trying to change the text of cells in the first row of the spreadsheet, essentially the column header.
This example is just changing the first cell in row 1.
Dim l_sValue As String
Id #9383 | Release:
| Updated: Wed at 4:52 PM by MDeLeon | Created: Oct 21 at 6:26 PM by JoelPettit
I came across an Excel file (I think from 2003 originally and re-saved as MS Office 2013 XLSX) which hit the GetPtValue private method in the XLWorksheet_Load.cs file and the string was "62px". As ...
Id #9382 | Release:
| Updated: Oct 20 at 3:35 PM by stackedactor | Created: Oct 20 at 3:35 PM by stackedactor
im trying to set font for Persian language but it seems it dose not work
when i download my excel file , the cell that i set the font is not changed but when i click on it the font name has...
Id #9380 | Release:
| Updated: Oct 20 at 12:03 PM by logicbloke | Created: Oct 16 at 11:11 AM by pouya_samie
My .xlsx file contains a Pivot Table. But I can't get access to it via Worksheet.PivotTables property.
This is my sample code:
using (var excel = new XLWorkbook(sourceFile, XLEventTracking.Enable...
Id #9378 | Release:
| Updated: Oct 15 at 4:15 PM by lionsoft | Created: Oct 15 at 4:15 PM by lionsoft
I am using the workbook.worksheets.add method with a data table that I get from an Oracle DB using ODP.NET, but numbers and dates are always formatted as text. I end up running methods to fix this...
Id #9377 | Release:
| Updated: Oct 15 at 1:14 PM by prashingkar | Created: Oct 14 at 4:27 PM by bobbeid
Se attached Excel document. It is currently being filled by manual data entry, which is a lot of work. The purpose of the application I am developing is to "clone" the "item 1" worksheet 'n' times ...
Id #9376 | Release:
| Updated: Oct 12 at 1:12 AM by TravisBanger | Created: Oct 12 at 12:07 AM by TravisBanger
When I freeze the first row, the scroll wheel no longer works. This is because the active pane is still set to the default of TopLeft (or TopRight, not sure which). So the scroll wheel is trying to...
Id #9374 | Release:
| Updated: Oct 14 at 4:49 PM by slockwood87 | Created: Oct 8 at 8:15 PM by slockwood87
Thanks for the amazing library. Really appreciate it.
I am using ClosedXML 0.75.0
I looked at the following documentation on how text with numbers can correctly show up in Excel without the err...
Id #9372 | Release:
| Updated: Oct 2 at 9:02 PM by prashingkar | Created: Oct 2 at 8:55 PM by prashingkar