C# mono Android Excel reader

 

using WeihanLi.Npoi

var iWorkbook = ExcelHelper.LoadExcel(fileName);

var sheet = iWorkbook.GetSheetAt(0);

for (int row = 0; row <= sheet.LastRowNum; row++)

{

if (sheet.GetRow(row) != null) //null is when the row only contains empty cells 

{

Console.WriteLine(sheet.GetRow(row).GetCell(0).ToString());

}

}

using NPOI.XSSF.UserModel;

using NPOI.SS.UserModel;

using System.IO;

XSSFWorkbook hssfwb;

   using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.Read))

   {

    hssfwb= new XSSFWorkbook(file);

   }

   ISheet sheet = hssfwb.GetSheetAt(0);

   for (int row = 0; row <= sheet.LastRowNum; row++)

   {

    if (sheet.GetRow(row) != null) //null is when the row only contains empty cells

    {

     Console.WriteLine(sheet.GetRow(row).GetCell(0).ToString());

}

   }