How to convert Excel Table to Simple Web Table?

0
27
Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

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


<table border=”1″>
<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—–

<style type=”text/css”>
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.

 

Don't miss out!
Subscribe To Newsletter

Receive top technical news, lesson ideas, travel tips and more!

Invalid email address
Give it a try. You can unsubscribe at any time.

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

LEAVE A REPLY

Please enter your comment!
Please enter your name here