How to use NPOI to read Excel spreadsheet that contains empty cells?

c# excel npoi
Yulia V picture Yulia V · Jul 4, 2013 · Viewed 8.8k times · Source

When I read Excel worksheet using NPOI, empty cells are skipped. For example, it the row contains A, B, , C and I read it using 

IRow row = sheet.GetRow(rowNb)

then row.Cells[1].ToString() will output B (as expected) but row.Cells[2].ToString() will output C instead of an empty string. Is there a way to keep empty cells? Thanks.

Answer

Richard Deeming picture Richard Deeming · Jul 4, 2013

Try the GetCell method with the MissingCellPolicy:

ICell cell = row.GetCell(2, MissingCellPolicy.RETURN_NULL_AND_BLANK);

Related questions

How to read file using NPOI

I found NPOI is very good to write Excel files with C#. But I want to open, read and modify Excel files in C#. How can I do this?

Read More
Trying to create a new .xlsx file using NPOI and write to it

Edit: I'm trying to write a small console application that will read in lines from an excel spreadsheet, parse the lines and write the fielded data to a new excel file. I'm using .NET and the NPOI library. I finally …

Read More
Does NPOI have support to .xlsx format?

Will NPOI DLL recognize .xlsx file? Currently I'm using NPOI 1.2.5 version DLL for Microsoft Excel 97-2003, but I need to access Excel sheets of extension .xlsx also. Will NPOI support the above? Code snippet: static void Main(string[] args) { XSSFWorkbook …

Read More