使用C#将HTML字符串导出到ASP.Net中的Excel文件

using System;
using System.IO;
using System.Web;
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;

public void ExportHtmlToExcel(string htmlContent, string fileName)
{
    // 创建一个内存流
    MemoryStream ms = new MemoryStream();

    // 创建一个PDF文档
    Document document = new Document(PageSize.A4);

    // 将PDF文档写入内存流
    PdfWriter.GetInstance(document, ms).CloseStream = false;

    // 打开文档
    document.Open();

    // 解析HTML内容并添加到文档
    var htmlarraylist = HTMLWorker.ParseToList(new StringReader(htmlContent), null);
    for (int k = 0; k < htmlarraylist.Count; k++)
    {
        document.Add((IElement)htmlarraylist[k]);
    }

    // 关闭文档
    document.Close();

    // 将PDF内容写入响应流
    Response.ContentType = "application/vnd.ms-excel";
    Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
    Response.Clear();
    Response.OutputStream.Write(ms.ToArray(), 0, ms.ToArray().Length);
    Response.Flush();
    Response.End();
}