Asked By
Any Hill
30 points
N/A
Posted on - 10/13/2012
Hello Experts,
How to import html form data to excel? I want to transfer all my html form in to the Microsoft excel form for recording purposes. I hope you can share with me the correct and accurate commands in order for me to transfer or import some files to Microsoft excel application. Your help will be much appreciated.
Thank you.
How to import html form data to excel?
Hello Miss,
Follow the link below:Â http://html.brothersoft.com/html-to-excel-converter.html
You can do your desired job by it. But the Excel file will not be as same as the html file you see. If you want them exactly same, then do it manually with proper formatting.
Thanks.
How to import html form data to excel?
Hi Any Hill,
I have read your concern about importing HTML data to MS Excel. I made a research about it and it is seemed that there are a lot of ways in importing that kind of data. You can check this site:
How to import HTML into Excel
It is very easy to understand because it has a pictures and step-by-step instruction.
NirmalTV: How to Import HTML tables to excel
The Link above may also help you.
Thanks.
How to import html form data to excel?
Hello Any Hill,
Â
Here's a sample code. Watch Tutorial on Youtube for additional knowledge about this.
Â
<%response.ContentType="application/vnd.ms-excel"%>Â
<html>Â
<head>Â
<style type="text/css">Â
td {padding:2em; background-color:yellow; border:1px dotted #000;}Â
</style>Â
</head>Â
<body>Â
<table>Â
<tr>Â
    <td>1</td>Â
     <td>2</td>Â
     <td>3</td>Â
     <td>4</td>Â
</tr>Â
<tr>Â
    <td>=sum(a1:d1)</td>Â
    <td>6</td>Â
   <td>7</td>Â
   <td>8</td>Â
</tr>Â
</table>Â
</body>Â
</html>
Â
Hope this helped you!
How to import html form data to excel?
Â
You can simply do it with MS Excel itself. Follow the Steps:
Â
1. Open an Excel Sheet and select the Data Tab in the ribbon.
Â
2. Click on From Web icon.
Â
3. A pop up window will open. Enter the web page URL you want to import.
Â
4. Click on Import.
Â
All HTML data from the web page are imported to the Excel.
Â
Thank you.