Performance issue when generating xlsx file with large amount of data

Hi, We have a requirement to generate xlsx file with two sheets. Each sheet contains around 5 lakhs of data and 10 columns. It is taking more time(more than an hour) to generate excel file. Please ...

Id #14130 | Release: None | Updated: Sep 6 at 12:09 PM by subha20mohan | Created: Sep 6 at 12:09 PM by subha20mohan

Create a bar chart using XSSFWorkbook

Dear All, I have an XSSFWorkbook and I need to create a bar chart, but I have not found anything on the internet and in the documentation for npoi. Has anyone ever had to do something like that? ...

Id #14129 | Release: None | Updated: Aug 28 at 3:02 PM by rpansonato | Created: Aug 28 at 3:02 PM by rpansonato

System.OutOfMemoryException: Exception While Excel Export

1. ISSUE GENERATE WHILE CREATING ROW WITH BELOW SET OF RECORDS. Exporting Excel Row: 130686 Exporting Excel Columns: 30 Columns __fieldValue:__ 02048906_00000 __Code:__ crow.CreateCell(cellind...

Id #14125 | Release: None | Updated: Aug 1 at 7:22 AM by umangvshah | Created: Jul 31 at 1:37 PM by umangvshah

WeekDay Function Uses Monday=1 Instead of Sunday=1

Excel default weekday start is Sunday=1 but NPOI uses Date.DayOfWeek() which follows ISO with Monday=1. The value displayed in excel hence is not the same as the value given by NPOI once the workbo...

Id #14114 | Release: None | Updated: Jun 29 at 11:07 AM by Zebrette | Created: Jun 29 at 11:07 AM by Zebrette

Document with links corrupted

MSO write that document corrupted and remove hyperlinks from /xl/worksheets/sheet1.xml LibreOffice 5.2.5.1 open document fine and links work but after resaving links missed too. Document sample att...

Id #14102 | Release: None | Updated: May 12 at 10:37 AM by quazi_node | Created: May 12 at 9:10 AM by quazi_node

Could not install package

Could not install package 'NPOI 2.3.0'. You are trying to install this package into a project that targets '.NETPortable,Version=v4.5,Profile=Profile78', but the package does not contain any assemb...

Id #14097 | Release: None | Updated: May 9 at 5:35 PM by ponchautf | Created: May 4 at 3:47 PM by amalroshand

Opening and saving existing XLSM spreadsheet detaches macros from controls

I have an XLSM spreadsheet which contains form controls with macros attached. Opening this spreadsheet with NPOI and then saving it causes all macros to be detached from controls. I have to manuall...

Id #14081 | Release: None | Updated: Mar 24 at 7:27 AM by mbrozdowski | Created: Mar 24 at 7:15 AM by ZbigniewG

DOCX Header Picture

Hi, I recently updated my version to 2.2.1 and in this version picture i put in the Header corrupts the document. The same code worked without a problem until this version.

Id #14077 | Release: None | Updated: Mar 22 at 8:19 AM by mitch_gaby | Created: Mar 22 at 8:19 AM by mitch_gaby

Npoi Round Formula

Hi, I' have this round problem: the number 37803.49142 was being used in the Excel ROUND() function to 0dp. e.g. ROUND(37803.49142, 0) When executing this using the same workbook: Excel would eva...

Id #14073 | Release: None | Updated: Mar 7 at 8:43 AM by Didacus | Created: Mar 7 at 8:43 AM by Didacus

Excel Error-In the Excel File multiple Sheet with pivot Table ,Excel Write Issue

Hi All team / I have the following issue and I hope you can help / explain it to me. I Have one template of excel file ,in this excel file 1st sheet is pivot table and 2nd normal data sheet ,but ri...

Id #14062 | Release: None | Updated: Feb 22 at 4:51 AM by SuryakantThopate | Created: Feb 22 at 4:51 AM by SuryakantThopate