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