Top "Npoi" questions

How to set "AutoSize" to Excel sheet column? (NPOI)

According to How can columns be set to 'autosize' in Excel documents created with NPOI? I did so: foreach (DataColumn …

c# .net excel npoi

How can columns be set to 'autosize' in Excel documents created with NPOI?

NPOI is a .NET port of the Java POI project, which allows one to read and write Microsoft Excel documents (…

excel npoi

NPOI set cell style

C# or VB.NET suggestion are welcome. I have the following code to create Excel file with NPOI. It's working …

c# vb.net npoi

NPOI - Get excel row count to check if it is empty

I'm reading an xlsx file using NPOI lib, with C#. I need to extract some of the excel columns and …

c# excel npoi

Custom color for ICellStyle FillForegroundColor than provided named colors

We are newly started using NPOI components. We are having issues to set FillForegroundColor of ICellStyle property. ICellStyle HeaderCellStyle = xssfworkbook.…

c# c#-4.0 npoi

MemoryStream seems be closed after NPOI workbook.write?

I am using NPOI to convert DataTable to Excel in a ASP.NET Web API project. But the I got …

c# excel asp.net-web-api npoi

Read excel using npoi cell range address

I know that NPOI is very awesome for create excel file. And now I want read excel in specific column. …

c# excel npoi

NPOI DataFormat

I'm exporting a grid with NPOI v1.2.3, and am having trouble getting cell formatting to work. I have a class …

c# xls npoi

SSIS Script Task cant find reference to assembly

I have an SSIS package that uses a script task to populate a datatable with data from a variety of …

c# dll ssis npoi

NPOI - saving workbook created from template file

It is my 2nd time dealing with NPOI. I'm creating a workbook from a template excel file like this. string …

asp.net asp.net-mvc excel asp.net-mvc-4 npoi