NPOI snippet

 1 var workbook = new XSSFWorkbook(stream);
 2 var sheet = workbook.GetSheetAt(0);
 3 
 4 var cr = new CellReference("D5");
 5 var row = sheet.GetRow(cr.Row);
 6 var cell = row.GetCell(cr.Col);
 7 
 8 var val = getCellValue(cell);
 9 
10 private object getCellValue(ICell cell)
11 {
12     object cValue = string.Empty;
13     switch (cell.CellType)
14     {
15         case (CellType.Unknown | CellType.Formula | CellType.Blank):
16             cValue = cell.ToString();
17             break;
18         case CellType.Numeric:
19             cValue = cell.NumericCellValue;
20             break;
21         case CellType.String:
22             cValue = cell.StringCellValue;
23             break;
24         case CellType.Boolean:
25             cValue = cell.BooleanCellValue;
26             break;
27         case CellType.Error:
28             cValue = cell.ErrorCellValue;
29             break;
30         default:
31             cValue = string.Empty;
32             break;
33     }
34     return cValue;
35 }