G Logic

There is no such function in JavaScript to remove the spaces at the beginning and end of the string. But you can use the following approaches to perform Trim operation .

There are two approaches to Trim String

Trim String Using Javascript Function

// Trim Function call Right Trim and Left Trim function to trim string

function trim(myString)

{

return LeftTrim(RightTrim(myString));

}

function LeftTrim(myString)

{

for(var k = 0; k < myString.length && IsWhitespace(myString.charAt(k)); k++);

return myString.substring(k, myString.length);

}

function RightTrim(myString)

{

for(var j=myString.length-1; j>=0 && IsWhitespace(myString.charAt(j)) ; j--) ;

return myString.substring(0,j+1);

}

function IsWhitespace(charToCheck) {

var whitespaceChars = " \t\n\r\f";

return (whitespaceChars.indexOf(charToCheck) != -1);

}

Trim string using Regular Expression

Function Trim(myString)

{

return myString.replace(/^s+/g,'').replace(/s+$/g,'')

}

Export HTML Table to Excel Using JavaScript / JQuery

Simple Code

function ExportToExcel(mytblId)

{

var htmltable= document.getElementById(mytblId);

var html = htmltable.outerHTML;

// MS OFFICE 2003 : data:application/vnd.ms-excel

// MS OFFICE 2007 : application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

window.open('data:application/vnd.ms-excel,' + encodeURIComponent(html));

}

</script>

We can Customize our table data on the fly using custom Export Function

Customize function to Export Data

function CustomMethodToExport(tblId)

{

var html ;

var numofRows ;

var gTable = document.getElementById(tblId);

numofRows = gTable.rows.length-1;

var numofCells ;

var trhtml = "";

numofCells = gTable.rows[0].cells.length-1 ;

for ( r = 0; r <= numofRows; r++)

{

var c =0;

var tdhtml = "" ;

for (c = 0; c<=numofCells; c++)

{

var tempstr = gTable.rows[r].cells[c].innerText ;

var color = "" ;

var isPercent = ""

if(tempstr.search("%") > 0)

{

if(tempstr.search('-') >= 0)

{

color = "red";

}

else

{

color = "green";

}

else

{

color = "black";

}

tdhtml = tdhtml + "<td style='text-align:right;color:"+ color +";'>" + gTable.rows[r].cells[c].innerText.replace(" ") + "</td>";

}

trhtml = trhtml + "<tr>" + tdhtml + "</tr>";

}

html = "<table border='1'>"+trhtml+"</table>";

// MS OFFICE 2003 : data:application/vnd.ms-excel

// MS OFFICE 2007 : application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

window.open('data:application/vnd.ms-excel,' + encodeURIComponent(html));

}

</script>

Export Data Using Jquery

$(window).load(function(){

$("#clickToExcel").click(function() {

var dtltbl = $('#mytbl').html();

window.open('data:application/vnd.ms-excel,' + $('# mytbl').html());

});

});//]]>

HTML Body Code

<body>

<div>

<tr>

<td>

<td>

<td>

<b>Profit/Loss</b></td>

</tr>

<tr>

<td>

1</td>

<td>

Tarun</td>

<td>

200%</td>

</tr>

<tr>

<td>

2</td>

<td>

Ajay</td>

<td>

-200%</td>

</tr>

</table>

<a id="clickToExcel" href="javascript:ExportToExcel('mytbl')">Export To Excel</a> | <a href="javascript:CustomMethodToExport('mytbl')">

Custome Export</a>

</div>

</form>

</body>

Note:

If you have special character problem then write down following code before Window.open method inside script function

  while (html.indexOf('á') != -1) html = html.replace('á', '&aacute;');

  while (html.indexOf('é') != -1) html = html.replace('é', '&eacute;');

  while (html.indexOf('í') != -1) html = html.replace('í', '&iacute;');

  while (html.indexOf('ó') != -1) html = html.replace('ó', '&oacute;');

  while (html.indexOf('ú') != -1) html = html.replace('ú', '&uacute;');

  while (html.indexOf('º') != -1) html = html.replace('º', '&ordm;');

Use MIME Type for MS Office 2003

application/vnd.ms-excel

Use MIME Type for MS Office 2007 :

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

G Logic

Wednesday 21 November 2012

JavaScript Trim() Function

There is no such function in JavaScript to remove the spaces at the beginning and end of the string. But you can use the following approaches to perform Trim operation .

Export html table to Excel using JavaScript / JQuery

Export HTML Table to Excel Using JavaScript / JQuery

We can Customize our table data on the fly using custom Export Function

Note:

Monday 19 November 2012

How to Convert width from percentage to pixels

Formula to calculate width in Pixels from percentage.