§ ITPOW >> 文档 >> .NET Core

作者：vkvi 来源：ITPOW（原创） 日期：2020-8-14

@page
@model IndexModel
@using NPOI.XSSF.UserModel;
@{
    ViewData["Title"] = "Home page";

    if (Request.ContentLength > 0)
    {
        
        XSSFWorkbook workbook = new XSSFWorkbook(Request.Form.Files[0].OpenReadStream());
        var sheet = workbook.GetSheetAt(0);
        var rows = sheet.GetRowEnumerator();
        int i = 0;
        while (rows.MoveNext())
        {
            // 跳过前面 3 行
            if (i < 3)
            {
                i++;
                continue;
            }
            XSSFRow row = (XSSFRow)rows.Current;
            var price = row.GetCell(5).NumericCellValue;
            var volume = row.GetCell(6).NumericCellValue;
            <p>@price-@volume</p>
        }
    }
}