3 Steps To Import Excel At .Net Core

Today I will tell you 3 steps to import excel at .Net Core.

  1. Install Spire.XLS, you can manage this at NuGet Package manager.


Figure: If you don’t have licence, you can use FreeSpire.XLS.

  1. import Spire.Xls;
1
using Spire.Xls;
  1. Enjoy
1
2
3
4
5
Workbook workbook = new Workbook();
workbook.LoadFromFile([fileURL/fileStream]);
Worksheet sheet = workbook.Worksheets[0];
CellRange range = sheet.Range[sheet.FirstRow, sheet.FirstColumn, sheet.LastRow, sheet.LastColumn];
DataTable dt = sheet.ExportDataTable(range, true, true);

Thanks for watching