Ad Home

Theme images by kelvinjay. Powered by Blogger.

Travel

Header Ads

Java

Selenium

UFT

Framework

General QA Concept

BDD

» » » How to convert Excel Table to Simple Web Table?

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



NameRoll NumberStatus
A1Passed
B2Failed
C3Passed


Hope this will help you to create excel data to simple webpage table.


«
Next
Newer Post
»
Previous
Older Post

No comments:

Leave a Reply