Open a solution, install EPPlus using manage nuget packages.
- if (fuExcelUpload.HasFile)
- {
- DataTable dt = new DataTable();
- if (Path.GetExtension(fuExcelUpload.FileName) == “.xlsx” || Path.GetExtension(fuExcelUpload.FileName) == “.xls”)
- {
- ExcelPackage package = new ExcelPackage(fuExcelUpload.FileContent);
- dt = package.ToDataTable();
- }
-
- }
-
- public static DataTable ToDataTable(this ExcelPackage package)
- {
- ExcelWorksheet workSheet = package.Workbook.Worksheets.First();
- DataTable table = new DataTable();
- foreach (var firstRowCell in workSheet.Cells[1, 1, 1, workSheet.Dimension.End.Column])
- {
- table.Columns.Add(firstRowCell.Text);
- }
-
- for (var rowNumber = 2; rowNumber <= workSheet.Dimension.End.Row; rowNumber++)
- {
- var row = workSheet.Cells[rowNumber, 1, rowNumber, workSheet.Dimension.End.Column];
- var newRow = table.NewRow();
- foreach (var cell in row)
- {
- newRow[cell.Start.Column – 1] = cell.Text;
- }
- table.Rows.Add(newRow);
- }
- return table;
- }
Exception Expected:
Could not load file or assembly ‘EPPlus, Version=4.0.5.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1’ or one of its dependencies. The system cannot find the file specified.
Solution:
Go to solution, right click on package –> Properties –> Advanced tab, add epplus.dll