在ASP.NET中执行Excel下载后的代码

using System;
using System.IO;
using System.Web;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;

public class ExcelDownloadHandler : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        // 创建工作簿和工作表
        IWorkbook workbook = new XSSFWorkbook();
        ISheet sheet = workbook.CreateSheet("Sheet1");

        // 添加表头
        IRow headerRow = sheet.CreateRow(0);
        headerRow.CreateCell(0).SetCellValue("Column1");
        headerRow.CreateCell(1).SetCellValue("Column2");

        // 添加数据行
        IRow dataRow = sheet.CreateRow(1);
        dataRow.CreateCell(0).SetCellValue("Data1");
        dataRow.CreateCell(1).SetCellValue("Data2");

        // 保存Excel文件到服务器临时目录
        string tempFilePath = Path.Combine(Path.GetTempPath(), "temp.xlsx");
        using (FileStream fs = new FileStream(tempFilePath, FileMode.Create))
        {
            workbook.Write(fs);
        }

        // 设置HTTP响应头，指定下载文件的类型和名称
        context.Response.ContentType = "application/vnd.ms-excel";
        context.Response.AddHeader("Content-Disposition", "attachment; filename=excel.xlsx");

        // 将Excel文件发送给客户端
        context.Response.TransmitFile(tempFilePath);
        context.Response.Flush();

        // 删除临时文件
        File.Delete(tempFilePath);
    }

    public bool IsReusable
    {
        get { return false; }
    }
}