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()) { openFileDialog.InitialDirectory = Form1.XlsxInitialDirectory; // "C:\\Users\\jason\\Downloads\\"; openFileDialog.Filter = "xlsx files (*.xlsx)|*.xlsx"; //"txt files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; openFileDialog.FilterIndex = 2; openFileDialog.R