log ClosedXML
Microsoft Visual Studio 1. NuGet Package Manager installs ClosedXML that depends DocumentFormat.OpenXml, ExcelNumberFormat, and WindowsBase. 2.using ClosedXML.Excel; using System; using System.Data; using System.Data.OleDb; using System.IO; 3. read .xlsx file using (var workbook = new XLWorkbook(xlsxfile)) { ... var ws = workbook.Worksheet(1); foreach (var row in ws.Rows()) {if (!row.IsEmpty()){string cell1 = row.Cell(1).GetValue<string>(); object value =row.Cell(1).Value; } } } 4. OpenFileDialog using (OpenFileDialog openFileDialog = new OpenFileDialog()) { ...