Julian Gonzalez

Generation

generate functionThu, 30 Mar 2023

Read excel file in .Net 6 using EPPlus library

using OfficeOpenXml; public DataTable ReadExcelFile(string path, string sheetName) { DataTable dt = new DataTable(); using (ExcelPackage package = new ExcelPackage(new System.IO.FileInfo(path))) { ExcelWorksheet workSheet = package.Workbook.Worksheets[sheetName]; foreach (ExcelRangeBase cell in workSheet.Cells) { if (cell.Start.Column == 1 && cell.Start.Row != 1) { dt.Rows.Add(); } if (cell.Start.Row == 1) { dt.Columns.Add(cell.Text); } else { dt.Rows[cell.Start.Row - 2][cell.Start.Column - 1] = cell.Text; } } } return dt; }

Questions about programming?Chat with your personal AI assistant