Save HTML Table to Excel using jQuery
After a few hours work looking into this, this turned out really easy to implement using jQuery and server side PHP programming as follows:
On the client side the following HTML code needs adding to the page (note this is older code – for newer code follow link at bottom):
<form action="/SaveToExcel.php" method="post" target="_blank" onsubmit='$("#datatodisplay").val( $("<div>").append( $("#ReportTable").eq(0).clone() ).html() )'> <input type="image" src="/images/icons/Floppy-48x48.png" width="12" height="12" > <input type="hidden" id="datatodisplay" name="datatodisplay" /> </form>
Note – variables used above – ReportTable is the id of the table you want to save and datatodisplay is a hidden variable used to post the table to the server.… Read the rest