I'm creating '.xlsx' file using ClosedXML. The code which i used is given below:
Here dsreport is a Dataset having multiple sheets.
using (XLWorkbook wb = new XLWorkbook())
Id #9445 | Release:
| Updated: Jun 20 at 9:38 AM by Suvarnni | Created: Jun 20 at 9:38 AM by Suvarnni
I am trying to set a text value to one of my columns.
Text value is 2015/06/03 15:15
Below is the code, that I use to set this column
excelWorkSheet.Cell(j + 1, k).SetDataType(XLCellValues.Tex...
Id #9444 | Release:
| Updated: Jun 3 at 4:02 PM by jineshv | Created: Jun 3 at 4:02 PM by jineshv
Document created with using SetRowsToRepeatAtTop function does not repeat rows for OpenOffice or LibreOffice.
Id #9443 | Release:
| Updated: Jun 1 at 2:30 PM by kDanil | Created: Jun 1 at 2:24 PM by kDanil
results in a "Syntax error." exception.
Code ends up in the ParseAtom() method with the _token.Type of TKTYPE.COMPARE, which is unsupported at that moment.
Id #9442 | Release:
| Updated: Jun 26 at 10:56 AM by Blaaznar | Created: Jun 1 at 11:53 AM by Blaaznar
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: May 26 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