Reading Excel Sheet in ASP.NET Core C#

Hello Austin,

Please refer below documantation.

https://github.com/ClosedXML/ClosedXML/wiki

XLWorkbook workbook = new XLWorkbook(FilePath);
 var rowCount = workbook.Worksheet(1).LastRowUsed().RowNumber();
 var columnCount = workbook.Worksheet(1).LastColumnUsed().ColumnNumber();
 int column = 1;
 int row = 1;
 List ll = new List();
 while (row <= rowCount)
 {
      while (column <= columnCount)
      {
         string title = workbook.Worksheets.Worksheet(1).Cell(row, column).GetString();
                ll.Add(title);
                column++;
       }

 row++;
 column = 1;
}

 

Thanks

Hi Austin,

You can take refrence from this article How to Read Excel Sheets in ASP.NET Core C# from Angular | Step-by-Step.

Article LInk:

https://www.codingvila.com/2024/07/how-to-read-excel-sheets-in-aspnet-core.html

Hi 

You can refer my article how to read data from Excel in c#.

https://www.c-sharpcorner.com/article/how-to-read-data-from-an-excel-sheet/