怎么把HTML转换成Excel? [英] How to convert Html to Excel?

问题描述

我有包含多个数据的html页面.我希望在excel中打印html结果.我的结果在垂直线上.但是我希望它们是水平的.

I had html page with multiple datas. I wish to print html result in excel. My results are in a vertical line. But i want them in a horizontal way.

<table border=0 cellspacing=0 cellpadding=0>
    <tr height=14>
        <td width=21 align=left>
            <br>
        </td>
        <td width=354 align=left>
            <font style=font-size:8pt face="arial" color=#333333>children clothing</font>
        </td>
        <td width=98 align=right>
            <font style=font-size:8pt face="arial" color=#000000>page 1 of 86</font>
        </td>
    </tr>
</table>

<table border=0 cellspacing=0 cellpadding=0>
    <tr height=14>
        <td width=21 align=left>
            <br>
        </td>
        <td width=477 align=left>
            <font style=font-size:8pt face="arial" color=#969696>_____________________________________________________________________________</font>
        </td>
    </tr>
</table>

<table border=0 cellspacing=0 cellpadding=0>
    <tr height=20>
        <td width=20 align=left>
            <br>
        </td>
        <td width=478 align=left>
            <b>
                <font style=font-size:11pt face="verdana" color=#333333>zion garments</font>
            </b>
        </td>
    </tr>
</table>

<table border=0 cellspacing=0 cellpadding=0 id="qmstable">
    <tr height=16>
        <td width=20 align=left>
            <br>
        </td>
        <td width=105 align=left>
            <font style=font-size:8pt face="verdana" color=#000000>address</font>
        </td>
        <td width=373 align=left>
            <font style=font-size:9pt face="verdana" color=#000000>59-f, sbi colony, gandhinagar, tirupur 641603</font>
        </td>
    </tr>
</table>

<table border=0 cellspacing=0 cellpadding=0>
    <tr height=16>
        <td width=20 align=left>
            <br>
        </td>
        <td width=105 align=left>
            <font style=font-size:8pt face="verdana" color=#000000>phone:</font>
        </td>
        <td width=373 align=left>
            <font style=font-size:9pt face="verdana" color=#000000>91-4212-477819</font>
        </td>
    </tr>
</table>

就像在多个表中的多个数据一样.

Like this multiple data in multiple table.

推荐答案

如果要手动执行此操作，请访问以下链接并将html上传到网站，它将转换为excel格式.

If you want to do this manually, visit the following link and upload your html to the website and it will convert to excel format.

http://www.convertcsv.com/html-table-to-csv.htm

或

要转换.html文件，请使用Excel(文件-打开)将其打开，然后从Excel中将其另存为.xlsx文件(文件-另存为).

To convert an .html file, open it using Excel (File - Open) and then save it as a .xlsx file from Excel (File - Save as).

这篇关于怎么把HTML转换成Excel?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！