# HTMLTable转换为Excel

最新推荐文章于 2023-07-23 21:37:11 发布

m0_46537704

最新推荐文章于 2023-07-23 21:37:11 发布

阅读量511

点赞数

分类专栏： HtmlTableToExcel 文章标签： excel html .net

本文链接：https://blog.csdn.net/m0_46537704/article/details/108620948

版权

HtmlTableToExcel 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

HTMLTable转换为EXcel

1.netcore3.0，.netFramework
2.nuget 下载office安装包![在这里插入图片描述](https://img-blog.csdnimg.cn/20200916113804736.png#pic_center
3.思路用Excel打开html，然后再另存为.xls文档
4.代码实现

public static string ReadHtmlToExcelFile(string readFileName, string saveFileName)
{

        Excel.WorkbookClass wbclass;
        Worksheet ws;
       Excel.Application excelApp;
       excelApp = new Microsoft.Office.Interop.Excel.Application();
       object objOpt = System.Reflection.Missing.Value;
       string path2 = Directory.GetCurrentDirectory();
       log.Info($"读取文件路径{path2}/{readFileName}");
       wbclass = (WorkbookClass)excelApp.Workbooks.Open(@$"{path2}/{readFileName}",
               objOpt,objOpt, objOpt, objOpt, objOpt,
              objOpt, objOpt, objOpt, objOpt, objOpt);//excel打开文件按
            ws = (Worksheet)wbclass.Worksheets.get_Item(1);
        //添加网格线
        ws.UsedRange.Borders.Color = Color.Black;
      
        wbclass.DefaultTableStyle = true;
        var b = wbclass;
        
     
        string path = $"{path2}\\{saveFileName }\\{DateTime.Now.ToString("yyyyMMddHHmmss")}.xls";
        b.SaveAs(path, 
              Excel.XlFileFormat.xlWorkbookNormal, objOpt, objOpt, objOpt, objOpt, Excel.XlSaveAsAccessMode.xlNoChange, objOpt, objOpt, objOpt, objOpt);//另存为xls
       
            excelApp.Workbooks.Close();
            excelApp.Quit();
        return path;
       // }
        
    }
    生成结果有跨行跨列，但是没有色彩
   5.调用
    [HttpPost]
    [Route("/ToExcel2")]
    [ValidateModelState]
    [SwaggerOperation("ToExce2lPost")]
    [SwaggerResponse(statusCode: 200)]
    public virtual IActionResult ToExcel2Post([FromBody] FileHtml html)
    {
        log.Warn($"ht");
        string readPath = $"Temp\\{DateTime.Now.ToString("yyyyMMddHHmmss")}{html.Name}.html";
        System.IO.File.WriteAllText(readPath, $"<html><head></head><body>{html.Html}</body></html>");//生成html文件
        string path=FileUnitity2.ReadHtmlToExcelFile(readPath, @"Temp");
        var fs= System.IO.File.ReadAllBytes(path);
        System.IO.File.Delete(path);
         System.IO.File.Delete(readPath);
        return  File(fs, "application/x-xls", $"{html.Name}.xls");
    }

public class FileHtml
{
public string Name { set; get; }//生成文件的名称
public string Html { set; get; }//需要转成Excel的htmlTable代码
}

示例：
{
“name”: “Test”,
“html”: “

<col style=“width: 176px; min-width: 176px;”><col style=“width: 106px; min-width: 106px;”><col style=“width: 106px; min-width: 106px;”><col style=“width: 88px; min-width: 88px;”><col style=“width: 88px; min-width: 88px;”><col style=“width: 88px; min-width: 88px;”><col style=“width: 88px; min-width: 88px;”><col style=“width: 106px; min-width: 106px;”><col style=“width: 106px; min-width: 106px;”><col style=“width: 87px; min-width: 87px;”><col style=“width: 87px; min-width: 87px;”><col style=“width: 87px; min-width: 87px;”><col style=“width: 87px; min-width: 87px;”><col style=“width: 17px; min-width: 17px;”><thead class=“ant-table-thead”><th rowspan=“2” class=“ant-table-cell ant-table-cell-fix-left ant-table-cell-fix-left-last” style=“text-align: center; position: sticky; left: 0px;”>時間<th colspan=“6” class=“ant-table-cell” style=“text-align: center;”>VMMC本局預報<th colspan=“6” class=“ant-table-cell” style=“text-align: center;”>实测<th class=“ant-table-cell ant-table-cell-scrollbar” rowspan=“2”><th class=“ant-table-cell haverColor” style=“text-align: center;”><div style=“white-space: nowrap;”>東經
°<th class=“ant-table-cell haverColor” style=“text-align: center;”><div style=“white-space: nowrap;”>北緯
°<th class=“ant-table-cell haverColor” style=“text-align: center;”><div style=“white-space: nowrap;”>持續風
(km/h)<th class=“ant-table-cell haverColor” style=“text-align: center;”><div style=“white-space: nowrap;”>移速
(km/h)<th class=“ant-table-cell haverColor” style=“text-align: center;”><div style=“white-space: nowrap;”>移向
(km/h)<th class=“ant-table-cell haverColor” style=“text-align: center;”><div style=“white-space: nowrap;”>距澳
(km)<th class=“ant-table-cell noColor” style=“text-align: center;”><div style=“white-space: nowrap;”>東經
°<th class=“ant-table-cell noColor” style=“text-align: center;”><div style=“white-space: nowrap;”>北緯
°<th class=“ant-table-cell noColor” style=“text-align: center;”><div style=“white-space: nowrap;”>持續風
(km/h)<th class=“ant-table-cell noColor” style=“text-align: center;”><div style=“white-space: nowrap;”>移速
(km/h)<th class=“ant-table-cell noColor” style=“text-align: center;”><div style=“white-space: nowrap;”>移向
(km/h)<th class=“ant-table-cell noColor” style=“text-align: center;”><div style=“white-space: nowrap;”>距澳
(km)

”
}

缺点：表结构必须由Table里的标签完成，不能是CSS，生成表格样式比较简单

m0_46537704

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
# HTMLTable转换为Excel

HTMLTable转换为EXcel1.netcore3.0，.netFramework2.nuget 下载office安装包![在这里插入图片描述](https://img-blog.csdnimg.cn/20200916113804736.png#pic_center3.思路用Excel打开html，然后再另存为.xls文档4.代码实现public static string ReadHtmlToExcelFile(string readFileName, string saveFileName
复制链接

扫一扫