NPOI:howtoreadexcelcellwhichhavingnoheader

I am trying to extract TEXT from a .xlsx Excel file using NPOI.

我试图使用NPOI从.xlsx Excel文件中提取TEXT。

Below is the link of sample Excel file:

以下是Excel文件示例的链接:

http://s29.postimg.org/i7rtrucaf/excel_File.png

The function ExcelDocumentToText extracts all the cell values, but not the cell which contains INR (cell F2)

ExcelDocumentToText函数提取所有单元格值,但不提取包含INR的单元格(单元格F2)

    static void ExcelDocumentToText(string path = @"..\..\..\01.xlsx")
    {
        StringBuilder textOfExcelDocumnet = new StringBuilder();
        ISheet sheet = null; IRow headerRow = null; IEnumerator allRows = null;

        using (FileStream ExcelFile = new FileStream(path, FileMode.Open, FileAccess.Read))
            xlsReaderObject = new XSSFWorkbook(ExcelFile);

        for (int j = 0; j 

switch (cell.CellType)
{ 
    case CellType.Blank:
        return string.Empty;
    case CellType.Boolean:
        return cell.BooleanCellValue;
    case CellType.Formula:
        return cell.CellFormula;
    case CellType.Numeric:
        return cell.NumericCellValue;
    case CellType.String:
        return cell.StringCellValue;
    default:
        return string.Empty;
}