CODEWITHSUNDEEP
htmlexcel
Kalai Shruthi
Kalai Shruthi

Reputation: 21

How to convert Html to Excel?

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.

Upvotes: 0

Views: 10357

Answers (2)

user3666158
user3666158

Reputation: 101

You can do this using libreoffice tags. I just reposted my old article on how to do this at http://wjmceachran.com/2020/04/create-excel-files-from-legacy-system-with-libreoffice/

Upvotes: 0

Lakindu Gunasekara
Lakindu Gunasekara

Reputation: 4271

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).

Upvotes: 1

Related Questions