NPOISample/Controllers/HomeController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Http;
using System.IO;
using Npoi.Core.HSSF.UserModel;
using Npoi.Core.SS.UserModel;
using Npoi.Core.XSSF.UserModel;
using System.Reflection;
using Npoi.Core.HSSF.Util;
using Newtonsoft.Json;
using Microsoft.AspNetCore.Hosting;
using System.Web;

namespace NPOISample.Controllers
{
    public class HomeController : Controller
    {
        private List<string> _columnNames = new List<string>();

        private ProcessResult _processResult = new ProcessResult();

        private Dictionary<string, string> _columnMappings = new Dictionary<string, string>()
        {
            { "序号","Id"},
            { "品牌","BrandName"},
            { "车型","CarModelName"},
            { "驱动方式","DriveMode"},
            { "发动机","Engine"},
            { "排量","Volume"},
            { "厂家","FactoryName"},
            { "上市年份","MarketYear"},
            { "备注","Remark"},
            { "错误信息","ErrorMessage"},
        };


        private IWebHostEnvironment _env;
        public HomeController(IWebHostEnvironment env)
        {
            _env = env;
        }

        public IActionResult Index()
        {
            return View();
        }

        public IActionResult About()
        {
            ViewData["Message"] = "Your application description page.";

            return View();
        }

        public IActionResult Contact()
        {
            ViewData["Message"] = "Your contact page.";