How To Read Excel File from memory stream using NPOI?

sam

378 Points

48 Posts

I am working on excel file (.xlsx/.xls) and csv file (.csv). After uploading, I have got in memory stream. And I need to read in memory stream using NPOI.

byte[] bytes = Convert.FromBase64String(fileBase64);
using (MemoryStream ms = new MemoryStream(bytes))
{
  //some code for reading excel from memory stream
}

.net c#excel memory-stream npoi

Views: 22368
Total Answered: 1
Total Marked As Answer: 0
Posted On: 17-May-2017 05:54

Share:

Answers

Smith

2890 Points

78 Posts

Try following code:

byte[] bytes = Convert.FromBase64String(fileBase64);
using (MemoryStream ms = new MemoryStream(bytes))
{
   NPOI.HSSF.UserModel.HSSFWorkbook hSSFWorkbook = new NPOI.HSSF.UserModel.HSSFWorkbook(ms);
   NPOI.SS.UserModel.ISheet sheet = hSSFWorkbook.GetSheetAt(0);
   for (int row = 1; row <= sheet.LastRowNum; row++)
   {
      var sheetRow = sheet.GetRow(row);
      if (sheetRow != null)
      {    
          //sheetRow.GetCell(0).StringCellValue;
           //sheetRow.GetCell(1).StringCellValue;
      }
   }
}

Posted On: 18-May-2017 04:45