c# HTML to excel

你可以使用C#的OpenXML SDK来将HTML转换为Excel。以下是一个简单的示例代码：

using System.IO;
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

public void ConvertHtmlToExcel(string htmlFilePath, string excelFilePath)
{
    // Load HTML file
    string html = File.ReadAllText(htmlFilePath);

    // Create Excel file
    using (SpreadsheetDocument document = SpreadsheetDocument.Create(excelFilePath, SpreadsheetDocumentType.Workbook))
    {
        WorkbookPart workbookPart = document.AddWorkbookPart();
        workbookPart.Workbook = new Workbook();

        WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();
        worksheetPart.Worksheet = new Worksheet(new SheetData());

        Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());
        Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" };
        sheets.Append(sheet);

        // Convert HTML to Excel
        SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<SheetData>();
        HtmlConverter converter = new HtmlConverter(worksheetPart);
        converter.ParseHtml(html, sheetData);
    }
}

需要注意的是，此方法只能将简单的HTML转换为Excel，复杂的HTML可能无法正确转换。