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>
to insert data. or you can convert Excel file to HTML format and get the code. This code can be placed inside webpage.
Both the cases have some disadvantages–
1. You need to expert in HTML coding to understand the logic better.
2. Junk unnecessary code need to be uploaded in the second case
3. Debugging will be tough
4. May destroy your webpage structure.
So what can be a good solution to convert Excel data to simple web format??? I found out the solution today.. Lets check out how it works..
The solution is
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.
