Stack Overflow
Stack Overflow

Questions tagged [npoi]

.NET version of the Apache POI (Java) project

This project is the .NET version of the Apache POI project (the Java API for Microsoft Documents). POI is an open source project which can help you read/write xls, doc, and ppt files, so it has wide applications. For example, you can use it to generate an Excel report without Microsoft Office suite installed on your server and it is more efficient than calling Microsoft Excel ActiveX in the background; you can also use it to extract text from Office documents to help you implement full-text indexing feature (most of time this feature is used to create search engines).

Latest stable version: 2.6.0 / 17 November 2022

Latest actual source code: https://github.com/nissl-lab/npoi

612 questions
-1
votes
1 answer

Null reference exception stops the code execution inside of try block

So I have a code segment where I am expecting a method that is repeatedly called from inside a loop to return null at one point - null is returned because the table cell that this method tries to read from is empty. And that part is clear, that's…
vinn23
  • 39
  • 4
-1
votes
1 answer

how can I insert a table in a XWPFTableCell with NPOI?

I was trying to use NPOI to create a word document from a template.Inside the document I was trying to insert a table in a table cell.The table cell has two paragraphs, I was trying to insert a table between the two paragraphs.
edjoker
  • 157
  • 1
  • 14
-1
votes
3 answers

Creating an Excel File with NPOI on UWP

I'm developing an UWP application that gets information about assets, groups them into batches and creates an Excel with that info. I'm using NPOI library and it doesnt throw any exception, but the excel file can't be read. My summarized code is…
krisam
  • 60
  • 5
-1
votes
1 answer

C# NPOI draw line chart to Excel when cell value on range 0.001 to 9.999 (fractional numbers)

C# NPOI draw line chart to Excel when cell value on range 0.001 to 9.999 (fractional numbers) I can draw chart when cell value is similar (0, 1, 2, ... 9) or other integer value but when i try use (0,293 or other fractional numbers) i saw error: …
Solty
  • 53
  • 1
  • 8
-1
votes
2 answers

How to get excel column with the column index in NPOI C#

I want to set the cell formula for columns k-P by using a loop and in c# i can only loop with integers, how do you actually get the column(E.G K,L,M,N,O,P) with the index? for looping through rows its pretty easy because they are just numbers but…
wren
  • 373
  • 5
  • 15
-1
votes
1 answer

Read and Write to the same Excel-File

i'm new here and i hope you are able to help me. I need an code to read from an excel- and xml-file and compare specific content. I still have the basic of the code and an Idea to read from the xml-file. the problem in my next step is how to read…
Christoph Steidle
  • 1
  • 1
-1
votes
1 answer

Accessing Excel File Located at Properties.Resources and keep here template

I have a big Excel file with multi sheets that I am using as a template to write data on and then save as a new file to disk. In debug mode, I read it from disk add data to it and save it in a different location without any problems. However, now I…
ajd.nas
  • 354
  • 2
  • 12
-1
votes
2 answers

NPOI xls "TEXT" function converting "/" to "-" on evaluate formulas

I am using NPOI to input a date into a spreadsheet, then inside the xls I have the formula =TEXT(InputDateNamedRange, "yyyy/MM") to format the date to text for use elsewhere. The problem is that the "/" in the format string is being replaced with a…
Divan
  • 9
  • 1
  • 3
-1
votes
2 answers

How to export 0.5 million rows to excel/csv (performance issue)?

Currently we are using NPOI for exporting some large data to excel(environment--asp.net mvc-4.0 ). Its taking us around a minute to export 30000 rows to excel. Now the requirement has changed and we want 500000 which is more then 10 times the…
Scorpio
  • 1,151
  • 1
  • 19
  • 37
-2
votes
1 answer

Can NPOI in API use Excel file in memory without saving to disk?

Using the NPOI package, can an API receive an Excel file (xlsx), use that file in memory to process, then return a second Excel file as the response, all without saving either file to disk, or do the files need to be saved to disk before being…
Rich Hopkins
  • 1,861
  • 15
  • 29
-2
votes
1 answer

Getting a corrupted XLS file using NPOI

I tried to debug this code, but I didn't manage. Do any of you have any idea why my script creates a corrupted XLS file? string strCaleSalvareTest = @"C:\Users\andrei.tudor\Documents\TipMacheta.xls"; HSSFWorkbook wbXLS; strEr = "Er"; try { …
Spoukey
  • 15
  • 6
-2
votes
2 answers

Convert aspx.cs code behind into an executable file

I am a junior level developer and I have a situation where a previous developer wrote an aspx page, named with a guid, so as not to be accidentally accessed by a user. Its function is to call stored procedures to get a list of recipients, and…
Matthew Carr
  • 35
  • 8
1 2 3
…
40
41