NPOI
NPOI copied to clipboard
A .NET library for reading and writing Microsoft Office binary and OOXML file formats.
Caching implemented for the result of HSSFCellStyle.GetDataFormatString() uses unguarded statics and is not thread safe. In a multi-threaded environment you may receive the format string for a different cell.
Hi I am trying to use NPOI in my asp.net core 2.2 library but I get a warning sign on the package when I installed it but it does not...
I know how to read a file on disk with: `using (FileStream file = new FileStream(` etc.. Is there a way to do the same from Memory stream or the...
如何在xlsx文件中绘制带箭头的线?
``` System.InvalidCastException: Unable to cast object of type 'NPOI.HSSF.Record.BOFRecord' to type 'NPOI.HSSF.Record.TabIdRecord'. at NPOI.HSSF.Model.InternalWorkbook.FixTabIdRecord() at NPOI.HSSF.Model.InternalWorkbook.CheckSheets(System.Int32 sheetnum) at offset 40 at NPOI.HSSF.Model.InternalWorkbook.SetSheetName(System.Int32 sheetnum, System.String sheetname) at NPOI.HSSF.UserModel.HSSFWorkbook.CreateSheet(System.String sheetname) at offset...
Hi, I am having an issue with NPOI removing background colors from my conditional formattings when reading and writing XLSX files. I am using Version 1.2.1. When using the following...
I've checked the code https://github.com/dotnetcore/NPOI/blob/947220dedb1fc506e764568159a95498295250cf/src/NPOI/SS/Util/SheetUtil.cs#L442 Looks you are just use the fixed width of the single half-width character with the content length to calating the cell width. But it's not...
 DotNetCore.NPOI 1.2.2 **protected ISheet Sheet;** //for each result I usualy add an AutoSizeColumn. However now I got a message "Could not load file or assembly 'System.Drawing.Common, Version=0.0.0.0, Culture=neutral" for...
I have a .xls sheet with multiple sheets. I'm using following code to read the excel using NPOI package: WorkbookFactory.Create(fs) where fs = new FileStream(feedFilePath, FileMode.Open, FileAccess.Read) WorkbookFactory.Create(fs) is throwing...
I have Workbook_1 that has worksheet_1 in it, and also the sheet has some macros programmed. If I want to clone Worksheed_1 into a new workbook (Workbook_2) , is it...