Slightly more advanced version of my previous script. This script handles if the table doesn’t have an ID which was a problem previously. It also paves the way for multiple export options including Excel, HTML and PDF – whatever your server can handle.

This code is slightly different to previous code as it will add the export buttons to all tables on the page that do not have a class of ‘noExcel’. Run this script from your jQuery ready() function. A simpler version of this code is available at http://www.topsemtips.com/2008/11/save-html-table-to-excel-using-jquery/:

var RandomIDToUse = 1000;
function AddActionsToTable(  )
{
$(" table:not(.noExcel)").each( function(i){
var TableID = this.id ;

if ( $(this).data('ToolBarAdded') === undefined) {
$(this).data('ToolBarAdded',1);
var TableName = this.id ;
if ( this.id == '' || this.id === undefined ){
TableName = "MyRandomID" + RandomIDToUse ;
$(this).attr('id',TableName);
RandomIDToUse++ ;
}
var FormID = 'form' + TableName ;
var SavetoID = 'saveto' + TableName ;
var DataToDisplayName = "datatodisplay" + TableName ;
var SaveToDisk =
"<div class='TableToolBar'>" +
"<form action='/reports/SaveData/SaveToExcel.php' method='post' target='_blank' id='" + FormID + "'" +
"onsubmit='$(\".DataToDisplay\", this ).val( $(\"<div>\").append( $(\"#" + TableName + "\").eq(0).clone() ).html() )'>" +
"<input type='hidden' id='" + DataToDisplayName + "' name='DataToDisplay' class='DataToDisplay' />" +
"<input type='hidden' id='" + SavetoID + "' name='SaveTo' val='' />" +
"</form>" +
"<input  type='image' src='/images/icons/page_excel.png' width='16' height='16' alt='Save to Excel' title='Save to Excel'" +
" onclick='$(\"input:checked\").attr(\"checked\",true); $(\"#" + SavetoID + "\").val(\"Excel\"); $(\"#" + FormID + "\").submit();' />" +
"  " +
"<input  type='image' src='/images/icons/doc_table.png' width='16' height='16' alt='Save to HTML' title='Save to HTML'" +
" onclick='$(\"input:checked\").attr(\"checked\",true); $(\"#" + SavetoID + "\").val(\"HTML\"); $(\"#" + FormID + "\").submit();' />" +
"  " +
"<input  type='image' src='/images/icons/doc_pdf.png' width='16' height='16' alt='Save to PDF' title='Save to PDF'" +
" onclick='$(\"input:checked\").attr(\"checked\",true); $(\"#" + SavetoID + "\").val(\"PDF\"); $(\"#" + FormID + "\").submit();' />" +
"</div>" ;
$(this).after( SaveToDisk ) ;
}
} ) ;

}