NPOI

NPOI copied to clipboard

"BITOR is completely unknown" exception error

1

Hello! In one of my excels I have a formula that uses the [BITOR function](https://support.office.com/en-us/article/bitor-function-f6ead5c8-5b98-4c9e-9053-8ad5234919b2), and when I try to evaluate the formulas inside a sheet, it throws the next...

Zynke

This project is a perfect ecology for the initial stage of .NET Core. At present, the official NPOI project has supported .NET Core. If you find a problem or a...

yang-xiaodong

AddPicture creates invalid file format on .NET Core 2.0 with v 1.0.2

7

I am trying to use the 1.0.2 version for .NET Core for this .AddPicture() method. I constantly get a "cannot be opened because there are problems with the contents" error...

DaleBingham

I created the file helloWorld.xlsx, filled first row with "Hello". Then executed the following: ``` using (var file = File.Open($"helloWorld.xlsx", FileMode.Open, FileAccess.ReadWrite)) { var workbook = WorkbookFactory.Create(file); var sheet =...

astorDev

NPOI and X-Server

6

Hi How are you? I hope you are doing well. I'm trying to use this library in Linux server without X-Server. When I tried to use the method AutoSizeColumns I...

npfernandeztheillet

GetTable()

1

There doesn't seem to be a GetTable() Method. May I suggest this be added?

TheColonel2688

Memory leak issue

2

Use NPOI in dotnet core web api to create excel file. The memory usage of the website is always rising.

limengning

NPOI.Util.RuntimeException: Buffer overrun i=6;endIndex=106502;writeIndex=106499

1

```csharp using (var stream = new MemoryStream()) { workbook.Write(stream); } ``` ERROR: ``` NPOI.Util.RuntimeException: Buffer overrun i=6;endIndex=106502;writeIndex=106499 at NPOI.Util.LittleEndianByteArrayOutputStream.CheckPosition(System.Int32 i) at offset 64 at NPOI.Util.LittleEndianByteArrayOutputStream.Write(System.Byte[] b) at offset 45 at...

sampsonye

ICell.CellStyle.IsLocked does not lock cell

2

**v2.3.0** Although ICell.CellStyle.IsLocked has a setter value the cell is not locked in the saved workbook. ``` var workbook = new XSSFWorkbook(); var sheet = workbook.CreateSheet("Sheet1"); var row = sheet.CreateRow(0);...

tub5

Invalid header signature

5

when i am trying to import data from some xls files NPOI.POIFS.FileSystem.NotOLE2FileException: 'Invalid header signature; read 0x6320656C6261743C, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document'

nrk6208