php - How to download multiple HTML tables to Excel using JavaScript -

-

i have page multiple html tables there...i need download html tables microsoft excel. current coding have can download first table need download tables.

this javascript have used:

<script type="text/javascript"> var tabletoexcel = (function() {   var uri = 'data:application/vnd.ms-excel;base64,'     , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/tr/rec-html40"><head><!--[if gte mso 9]><xml><x:excelworkbook><x:excelworksheets><x:excelworksheet><x:name>{worksheet}</x:name><x:worksheetoptions><x:displaygridlines/></x:worksheetoptions></x:excelworksheet></x:excelworksheets></x:excelworkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'     , base64 = function(s) { return window.btoa(unescape(encodeuricomponent(s))) }     , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }   return function(table, name) {     if (!table.nodetype) table = document.getelementbyid(table)     var ctx = {worksheet: name || 'worksheet', table: table.innerhtml}     window.location.href = uri + base64(format(template, ctx))   } })() </script>

and portion of php table populated:

<div id="render_me">  <table width='100%' id="testtable"> <col width="15%" />         <col width="10%" />     <col width="25%" /> <col width="15%" />     <col width="10%" /> <col width="15%" />     <col width="10%" /> <tr> <th><?php echo $b;  //row id ?></th>           <th class='forcedwidth1'>merk</th>      <th class='forcedwidth1'>artikel naam</th> <th>ean</th>     <th>prijs kieskeurig.nl</th>         <th>verschil kieskeurig.nl</th>     <th>ral prijs</th>   </tr>     <?php    while($row=mysql_fetch_object($sql)):?>   <tr> <td width:'90px'></td> <td class='forcedwidth1'><?php echo $row->merk;  //row id ?></td>   <td class='forcedwidth1'><?php echo (utf8_decode($row->om));  //row id ?></td>   <td class='forcedwidth'><?php echo(utf8_decode("<a href=".$row->tw_url.">".$row->ean."</a>")); ?></td> <td class='forcedwidth'><?php $num2 = $row->price; echo number_format($num2,2,'.', ''); ?></td>     <td class='forcedwidth'><?php $num6 = $num2 - $row->ral; echo number_format($num6, 2, '.', ''); // row first name ?></td>     <td class='forcedwidth'><?php echo $row->ral; // row first name ?></td>    </tr>   <?php endwhile;?> </table>    <?php } }?> <?php }?> <button id="btnexport" class="button2"></button> <button onclick="demopdf()" class="button1">               </button>   </div> <input type="button" onclick="tabletoexcel('testtable', 'w3c example table')" value="export excel">

any appreciated.


Comments

Post a Comment

Popular posts from this blog

javascript - how to protect a flash video from refresh？ -

-
<!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>flash video refresh</title> </head> <body> <div id="playerzone"><embed height="496" width="580" flashvars="flvid=19742822&amp;createtime=2012-4-19 13:46:33" wmode="opaque" allowscriptaccess="always" allowfullscreen="true" quality="high" bgcolor="#000000" name="player" id="player" src="swf/mine.swf" type="application/x-shockwave-flash"></div> <a onclick="return test();" id="test">click me popup div,and hide scrollbar</a> </body> the code upon： for example,when click a#test button,popup div,it's no problem,but want hide scrollbar while div popup. i used $('html').css('overflow','hidden') in
Read more

android - Associate same looper with different threads -

-
Image
in application, want create multiple threads working on single queue. create queue know need call looper.prepare() . i want other threads create should associated looper created first thread, how can achieve this? use 1 of java thread safe queue class java.util.concurrent package instead of looper achieve goal. it's more common practice. share queue between threads , post task queue entry 1 thread can entry thread. blockingqueue can - in 1 thread call take() , block thread until thread put() entry queue. that's all. producer consumer pattern example blockingqueue or concurrentlinkedqueue about blockingqueue
Read more

visual studio 2010 - Connect to informix database windows form application -

-
i trying figure out how connect ibm informix database. have been doing research , have found threads 5 years ago examples not working. i have installed latest sdk ibm informix. i have included ibm.data.informix.dll references in project. i have included using ibm.data.informix; i adding button , on click testing conenction. debug error "sql0035n file "c:\users\adam\documents\visual studio 2010\projects\test\test\msg\en_us\db2nmp.xml" cannot opened." this file not exist , dont see anywhere in program files (x86)\ibm informix client sdk directory. my on click code is private void button1_click(object sender, eventargs e) { const string host = "192.168.obfuscated"; const string servicenum = "1525"; //port? const string server = "serverobfuscated"; const string database = "dbobfuscatedy"; const string user = "myusername"; const string password = &
Read more