Is it possible to get a column formatted as a number using the stream types?

My question comes from: https://stackoverflow.com/questions/47063178/npoi-excel-column-formatted-to-decimal-with-sxssfworkbook I have to export a table from a DB to Excel. I get all column types p...

Id #14146 | Release: None | Updated: Nov 4 at 10:45 PM by SonhanDev | Created: Nov 4 at 10:45 PM by SonhanDev

NPOI Exception "Extern sheet is part of LinkTable". Can not create HSSFWorkbook object from FileStream.

Below code throw an exception "Extern sheet is part of LinkTable" (using NPOI 2.3.0) HSSFWorkbook xlsFile; using (var fileRead = new FileStream(FileName, FileMode.Open, FileAccess.Read)) { try { x...

Id #14145 | Release: None | Updated: Oct 28 at 12:31 PM by Telnoff | Created: Oct 25 at 9:06 AM by Telnoff

The method or operation is not implemented exception

I am using the latest version of NPOI i.e. 2.3.0.0 for exporting a large number of data. Now, I am getting the exception at calling SetCellValue method of ICell as The method or operation is not im...

Id #14134 | Release: None | Updated: Sep 25 at 1:28 PM by Rutuja | Created: Sep 25 at 1:28 PM by Rutuja

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 1:09 PM by subha20mohan | Created: Sep 6 at 1: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 4:02 PM by rpansonato | Created: Aug 28 at 4: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 8:22 AM by umangvshah | Created: Jul 31 at 2: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 12:07 PM by Zebrette | Created: Jun 29 at 12:07 PM 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 11:37 AM by quazi_node | Created: May 12 at 10: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 6:35 PM by ponchautf | Created: May 4 at 4: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: Oct 24 at 8:50 AM by FlauzerOriginal | Created: Mar 24 at 8:15 AM by ZbigniewG