How to convert Excel Table to Simple Web Table?
If you are interested to upload the excel table data to a webpage then this article will help you.
Let us understand why I am not going for traditional approach.
So say you have a table with result of an exam
Where you have 3 students and and their result of a subject need to be published.
so either you can create
<tbody>
<tr> <td></td> <td></td> <td></td> </tr>
<tr> <td></td> <td></td> <td></td> </tr>
<tr> <td></td> <td></td> <td></td> </tr>
</tbody>
</table>
Yes…
There are few simple steps to convert Excel data to web table
Steps:
1. Copy your excel data sheet
2. Paste it to Tableizer
Step-1
Step-2
Step-3
Change the style
- Font size
- Header color
- Font
Step-4
Click on tableize it.
or you can reset to start a new one
The output code-
Even you can see the webtable output:
The code will look like—-
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
<table class=”tableizer-table”>
<tr class=”tableizer-firstrow”><th>Name</th><th>Roll Number</th><th>Status</th></tr>
<tr><td>A</td><td>1</td><td>Passed</td></tr>
<tr><td>B</td><td>2</td><td>Failed</td></tr>
<tr><td>C</td><td>3</td><td>Passed</td></tr></table>
The original output will be-
Name | Roll Number | Status |
---|---|---|
A | 1 | Passed |
B | 2 | Failed |
C | 3 | Passed |
Hope this will help you to create excel data to simple webpage table.