XLWorkbook wb = new XLWorkbook(templateFullName);
IXLWorksheet ws = wb.Worksheet(1);
ws.PageSetup.Footer.Right.AddText("created:" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
does not work.
Id #9441 | Release:
| Updated: Tue at 6:30 PM by doxakis | Created: May 21 at 6:48 AM by Kenichi_YAMADA
ws.Range(row1, col1, row2, col2).Style.Border.InsideBorder = XLBorderStyleValues.Thin;
always work at 1st worksheet.
ws.Cell(row1, col1).Style.Border.InsideBorder = XLBorderStyleValues.Thin;
Id #9440 | Release:
| Updated: May 21 at 6:24 AM by Kenichi_YAMADA | Created: May 21 at 6:24 AM by Kenichi_YAMADA
I want to open a file created by ClosedXML.Excel and then user Spire.XLS to save it as a PDF.
The following code creates a simple Excel file using ClosedXML.Excel.
If I try to open the file usin...
Id #9439 | Release:
| Updated: May 20 at 5:30 AM by gaffer1964 | Created: May 20 at 5:30 AM by gaffer1964
I use ClosedXML to create Excel Workbooks in Microsoft NAV 2013R2. In my development environment everything works without problems. When I try to execute the function in the customer environment I ...
Id #9438 | Release:
| Updated: May 19 at 9:15 AM by rodotto | Created: May 19 at 9:05 AM by rodotto
NullReferenceException occurs in XLWorkbook_Load method when opening attached XLSX file:
var xl = new XLWorkbook("Bug_118703_WriteMatrixToExcelNullReferenceException.xlsx");
Id #9437 | Release:
| Updated: May 19 at 9:23 AM by borismod | Created: May 19 at 6:58 AM by borismod
Currently if we use cell.CellRight(), we can traverse the cells as if they were unmerged. This is fine. However, this imposes strict requirements on file structure of my users. If they choose to me...
Id #9436 | Release:
| Updated: May 17 at 12:04 PM by baba147 | Created: May 17 at 12:04 PM by baba147
The following code
XLWorkbook xw = new XLWorkbook();
IXLWorksheet ws = xw.AddWorksheet("ASheet");
ws.Cell("A1").Value = 2;
ws.Cell("A2").Value = 1;
ws.Cell("A3").Value = 3;
ws.Cell("A4").Value = 1...
Id #9435 | Release:
| Updated: May 7 at 4:29 PM by morca | Created: May 7 at 2:18 PM by morca
When adding a comment to a cell extra empty cells are added in the excel sheet which are not touched by the code.
With the following code:
var workbook = new XLWorkbook();
var worksheet = workboo...
Id #9434 | Release:
| Updated: May 7 at 12:26 PM by ErwinSteffens | Created: May 7 at 12:26 PM by ErwinSteffens
A customer-provided Excel document contained a Formula referencing a second file using a formula like
which results in a System.Exception: Identifier expected.
Id #9433 | Release:
| Updated: May 6 at 12:43 PM by sopelt | Created: May 6 at 12:43 PM by sopelt
Great library but one trouble here - if you like to copy and modify rows often you touch row's height property . Then library sets height as CustomHeight.
So it seems the most simple way looks l...
Id #9432 | Release:
| Updated: Apr 30 at 10:32 PM by lvm99 | Created: Apr 30 at 10:32 PM by lvm99