How to convert Html to Excel?

2019-09-02 04:47发布

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
1条回答
贼婆χ
2楼-- · 2019-09-02 05:14

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

or

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

查看更多
登录 后发表回答