Changing a Column Header's text

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 l_sValue ...

Id #9383 | Release: None | Updated: Tue at 6:26 PM by JoelPettit | Created: Tue at 6:26 PM by JoelPettit

Addition of PX as a knownUnit in XLWorkSheet_Load.cs

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: None | Updated: Mon at 3:35 PM by stackedactor | Created: Mon at 3:35 PM by stackedactor

font for arabic/persian language

Hi 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: None | Updated: Mon at 12:03 PM by logicbloke | Created: Oct 16 at 11:11 AM by pouya_samie

Worksheet.PivotTables is always empty

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: None | Updated: Oct 15 at 4:15 PM by lionsoft | Created: Oct 15 at 4:15 PM by lionsoft

Date/Number Formatting Issue using Worksheets.Add

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: None | Updated: Oct 15 at 1:14 PM by prashingkar | Created: Oct 14 at 4:27 PM by bobbeid

Cell with Accounting Format produces crash during String Table creation

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: None | Updated: Oct 12 at 1:12 AM by TravisBanger | Created: Oct 12 at 12:07 AM by TravisBanger

Freezing first row causes scroll wheel to no longer work.

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: None | Updated: Oct 14 at 4:49 PM by slockwood87 | Created: Oct 8 at 8:15 PM by slockwood87

SetDataType(XLCellValues.Text) for setting Text with numbers does not work

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: None | Updated: Oct 2 at 9:02 PM by prashingkar | Created: Oct 2 at 8:55 PM by prashingkar

IXLColumn.AdjustToContents doesn't work correctly on a HighDPI display

When using a HighDPI display, IXLColumn.AdjustToContents doesn't work as expected; it makes the columns too long, probably by the same percentage as currentDPI / 96. The problem is probably aroun...

Id #9371 | Release: None | Updated: Sep 29 at 7:59 PM by MDeLeon | Created: Sep 29 at 7:16 PM by agarwal6

Unable to create mutex (Exception from HRESULT 0x80131464) - SaveAs into MemoryStream

Hi, I would like to know if you have any idea with the following issue, basically we are opening an excel file (xlsm) and doing some changes on it (cell colors, adding values to some cells.. etc...

Id #9368 | Release: None | Updated: Sep 17 at 3:34 PM by MDeLeon | Created: Sep 11 at 8:14 PM by LucasNET2