从C#中读取Excel文件

Install-Package EPPlus

using OfficeOpenXml;

using (var package = new ExcelPackage(new FileInfo("path/to/file.xlsx")))
{
    var worksheet = package.Workbook.Worksheets["Sheet1"];
    var cellValue = worksheet.Cells["A1"].Value;
}

Install-Package NPOI

using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;

using (var file = new FileStream("path/to/file.xlsx", FileMode.Open, FileAccess.Read))
{
    var workbook = new XSSFWorkbook(file);
    var worksheet = workbook.GetSheetAt(0);
    var cellValue = worksheet.GetRow(0).GetCell(0).StringCellValue;
}