ASP.NET Core 教學 - Open XML SDK 匯入 Excel

<form method="post" enctype="multipart/form-data" action="/api/import">
    <input type="file" name="files" accept="application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" />
    <input type="submit" value="送出" />
</form>

using System.Linq;
using System.Threading.Tasks;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using Microsoft.AspNetCore.Mvc;
using MyWebsite.Filters;

namespace MyWebsite.Controllers
{
    [Route("api/[controller]")]
    public class ImportController : Controller
    {
        [HttpPost]
        [DisableFormValueModelBinding]
        public async Task<IActionResult> Post()
        {
            await Request.StreamFile(file =>
            {
                using (var document = SpreadsheetDocument.Open(file.FileStream, false))
                {
                    var workbookPart = document.WorkbookPart;
                    var sheet = workbookPart.Workbook.Sheets.GetFirstChild<Sheet>();
                    var worksheet = ((WorksheetPart)workbookPart.GetPartById(sheet.Id)).Worksheet;
                    var sheetData = worksheet.GetFirstChild<SheetData>();

                    foreach (var row in sheetData.ChildElements.Select(x=>x as Row))
                    {
                        // 取得每一行
                        foreach(var cell in row.ChildElements.Select(x => x as Cell))
                        {
                            // 取得每一欄
                            var innerText = cell.CellValue.Text;
                            // Do somethings
                        }
                    }
                }
                return file.FileStream;
            });
            return Ok();
        }
    }
}