Excel导入导出/Controllers/ExcelController.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using NPOI;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using System.IO;
using NPOI.XSSF.UserModel;

namespace Excel导入导出.Controllers
{
    public class ExcelController : Controller
    {
        // GET: Excel
        public ActionResult Index()
        {
            return View();
        }

        //https://blog.csdn.net/kenhotmail/article/details/108277195
        //https://cloud.tencent.com/developer/ask/sof/103255971?from=ask.detail.122479
        //https://cloud.tencent.com/developer/ask/sof/122479
        //

        public FileResult Export()
        {
            MemoryStream ms = new MemoryStream();
            DataTable Dt = new DataTable("test");


            Dt.Columns.Add("Name");
            DataRow newDr1 = Dt.NewRow();
            newDr1["Name"] = "51Aspx";
            Dt.Rows.Add(newDr1);


            //新建一个EXCEL
            HSSFWorkbook workbook = new HSSFWorkbook();
            
            ISheet sheet = workbook.CreateSheet(Dt.TableName);
            //在sheet里创建行
            NPOI.SS.UserModel.IRow row1 = sheet.CreateRow(0);
            //第一行列名
            row1.CreateCell(0).SetCellValue(Dt.Columns[0].ColumnName);
            
            //数据
            IRow row2 = sheet.CreateRow(1);
            //1
            row2.CreateCell(0).SetCellValue(Dt.Rows[0][0].ToString());
           





            workbook.Write(ms);
            ms.Flush();