I was willing to write a blog .... and that blog was a tabular data. I wrote the content in excel ...when i try to put in blogger it was a difficult task !!!
If any ways you convert your data in html table ....blogger will add lines above the table because of each enter ...so you need a one line string for your table. I did it in a very simple way using following online tool:
http://tableizer.journalistopia.com/
This is a great tools it gives you html table without any new line ...It also gives some style to your table ....You just need to copy and paste the output data into your blogger(Edit HTML tab) . Dont forget to put column header in the excel data ...because this site will give you nice look for your header row :)
Monday, December 27, 2010
TSV To CSV Converter
Sometimes there is a need to convert a tab separated text file (.tsv) to a comma separated text file (.csv) .
I have created a utility using .net windows application .
This utility allow you to chosse a .tsv file and let you a select a path in your system where you want to create the output csv file.the filename will the same of the tsv file but the extension will be changed to .csv .
You can download this utility from here TSV To CSV Converter . Here i can not upload exe so you have change the extension of the file from .abc to .exe . You should have .net framework to run this utility .
I have created a utility using .net windows application .
This utility allow you to chosse a .tsv file and let you a select a path in your system where you want to create the output csv file.the filename will the same of the tsv file but the extension will be changed to .csv .
You can download this utility from here TSV To CSV Converter . Here i can not upload exe so you have change the extension of the file from .abc to .exe . You should have .net framework to run this utility .
Sunday, December 19, 2010
Very simple striped table with row hover effect
JQuery made it very easy to do tis task .... and just with basics of JQuery .JQuery allows us to find all the alternate rows of a table with tbody tr:even selector . We just need to apply a class to all the even rows thats it . To give some hover effect we can use mouseover and mouseout events . In mouseover we are just adding a class and in mouseout we are removing a class.
JQuery code :
<script type="text/javascript" language="javascript">
$(document).ready(function() {
// Initialise the table
$("#table-1 tbody tr:even").addClass("even");
$("#table-1 tbody tr:odd").addClass("odd");
$("#table-1 tbody tr td").addClass("BorderBottom");
$("#table-1 thead tr ").addClass("header");
$("#table-1 tbody tr").mouseover(function(){
$(this).addClass("over");
});
$("#table-1 tbody tr").mouseout(function(){
$(this).removeClass("over");
});
});
</script>
CSS Used :
.even
{
background-color:#C6DEFF;
}
.odd
{
background-color:#ffffff;
}
.BorderBottom
{
border-bottom:solid 1px blue;
text-align:center;
}
.over
{
background-color:#C6EEFF;
}
.header
{
background-color:Gray;
color:White;
}
The HTML Table
<table id="table-1" align="center" frame="vsides" width="70%" cellspacing="0" cellpadding="2">
<thead>
<tr>
<th>Col1</th><th>Col2</th><th>Col3</th>
</tr>
</thead>
<tbody>
<tr id="1">
<td>1</td><td>One</td><td>some text</td>
</tr>
<tr id="2">
<td>2</td><td>Two</td><td>some text</td>
</tr>
<tr id="3"><td>3</td><td>Three</td><td>some text</td>
</tr>
<tr id="4"><td>4</td><td>Four</td><td>some text</td>
</tr>
<tr id="5">
<td>5</td><td>Five</td><td>some text</td></tr>
<tr id="6">
<td>6</td><td>Six</td><td>some text</td>
</tr>
</tbody>
</table>
And we are done... below is the alternate colored row table with hover effect :
JQuery code :
<script type="text/javascript" language="javascript">
$(document).ready(function() {
// Initialise the table
$("#table-1 tbody tr:even").addClass("even");
$("#table-1 tbody tr:odd").addClass("odd");
$("#table-1 tbody tr td").addClass("BorderBottom");
$("#table-1 thead tr ").addClass("header");
$("#table-1 tbody tr").mouseover(function(){
$(this).addClass("over");
});
$("#table-1 tbody tr").mouseout(function(){
$(this).removeClass("over");
});
});
</script>
CSS Used :
.even
{
background-color:#C6DEFF;
}
.odd
{
background-color:#ffffff;
}
.BorderBottom
{
border-bottom:solid 1px blue;
text-align:center;
}
.over
{
background-color:#C6EEFF;
}
.header
{
background-color:Gray;
color:White;
}
The HTML Table
<table id="table-1" align="center" frame="vsides" width="70%" cellspacing="0" cellpadding="2">
<thead>
<tr>
<th>Col1</th><th>Col2</th><th>Col3</th>
</tr>
</thead>
<tbody>
<tr id="1">
<td>1</td><td>One</td><td>some text</td>
</tr>
<tr id="2">
<td>2</td><td>Two</td><td>some text</td>
</tr>
<tr id="3"><td>3</td><td>Three</td><td>some text</td>
</tr>
<tr id="4"><td>4</td><td>Four</td><td>some text</td>
</tr>
<tr id="5">
<td>5</td><td>Five</td><td>some text</td></tr>
<tr id="6">
<td>6</td><td>Six</td><td>some text</td>
</tr>
</tbody>
</table>
And we are done... below is the alternate colored row table with hover effect :
| Col1 | Col2 | Col3 |
|---|---|---|
| 1 | one | some text |
| 2 | two | some text |
| 3 | three | some text |
| 4 | four | some text |
| 5 | five | some text |
| 6 | six | some text |
Subscribe to:
Posts (Atom)
