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: Tue at 6:26 PM by JoelPettit | Created: Tue 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: Mon at 3:35 PM by stackedactor | Created: Mon 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: Mon 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
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:
| Updated: Thu at 4:23 PM by LostTime77 | Created: Sep 29 at 7:16 PM by agarwal6
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:
| Updated: Sep 17 at 3:34 PM by MDeLeon | Created: Sep 11 at 8:14 PM by LucasNET2