Error at the end of for when trying to execute a code

Question

I'm getting an error when trying to run my code, it's reading the excel lines, but at the end of reading all the lines it's giving the error below.

My controller:

       [HttpPost]
       public IActionResult MostrarDados([FromForm] IFormFile ArquivoExcel)
       {
           Stream stream = ArquivoExcel.OpenReadStream();

           IWorkbook MeuExcel = null;

           if (Path.GetExtension(ArquivoExcel.FileName) == ".xlsx")
           {
               MeuExcel = new XSSFWorkbook(stream);
           }
           else
           {
               MeuExcel = new HSSFWorkbook(stream);
           }

           ISheet FolhaExcel = MeuExcel.GetSheetAt(0);

           int QtdFilas = FolhaExcel.LastRowNum;

           List<VMProduct> list = new List<VMProduct>();

           for (int i = 1; i <= QtdFilas; i++)
           {
               IRow fila = FolhaExcel.GetRow(i);

               list.Add(new VMProduct
               {
                   Id_Item = fila.GetCell(0).ToString(),
                   Nome_Item = fila.GetCell(1).ToString(),
                   Qtd_Estoque = fila.GetCell(2).ToString(),
                   Preco_por = fila.GetCell(3).ToString(),
               });
           }

           return StatusCode(StatusCodes.Status200OK, list);
       }
   }
}

Error:

Something in that line is producing `null` and your call to `.ToString()` is causing a `null` reference exception — Ryan Wilson, Jul 28 '22 at 18:24
A row of mine was going with a comma, I think that's why it was giving an error. I believe it works now. But how can I use a float-type row? I can only use ".ToString()" — VICTOR MARCONI SANTOS DE OLIVE, Jul 28 '22 at 18:31
And I also couldn't show my list on the screen, it was blank, is something missing? — VICTOR MARCONI SANTOS DE OLIVE, Jul 28 '22 at 18:37

Error at the end of for when trying to execute a code

0 Answers0