Read xssftable using NPOI in C#

See more:

C#

ASP.NET

Hi

I want to read XSSFTable all data from excel sheet using NPOi

i am not able to use properties like tbl.GetEndCellReference.getRows()

PLease help.

What I have tried:

using (var fs = new FileStream(@"D:\ConvetDT\NpoiTable.xlsx", FileMode.Open, FileAccess.Read))
           {

               var wb = new XSSFWorkbook(fs);

               for (int i = 0; i < wb.Count; i++)
               {

                  var sheet=(XSSFSheet)wb.GetSheet("Formtable");
                   var table = sheet.GetTables();
                   foreach(var tab in table)
                   {
                      int startCellIndex=tab.GetStartCellReference().getRows()
                       int endCellIndex=tab.GetEndCellReference().getRows();// this is giving error

                   }
                   var row1 =sheet.GetRow(0).Cells[0];

               }
           }