Astuces Excel
  1. Astuces Excel
  3. Comment exporter la valeur d'un button radio vers Excel
Intereting Posts
Macro pour modifier les dates et générer une feuille de calcul sur le site Web Erreur de compilation VBA (Erreur d'automation 1004) Trouver et coller de la valeur entre les feuilles Excel Script Python pour parsingr un grand cahier de travail Recherche d'une valeur de text dans plusieurs files excel et copy ci-dessous valeur de la cellule au file maître Changer la hauteur du tableau croisé dynamic pour correspondre à la hauteur du tableau croisé dynamic Ligne vide supplémentaire dans ListBox alimenté par tableau Erreur lors de la lecture du file Excel avec vb .net OleDB Comment append une invite de mot de passe en cliquant sur l'onglet Excel Création de liens hypertext basés sur une cellule distincte Modification de la couleur des cellules à l'aide du button de command (VBA Excel) Conditions multiples pour le formatting conditionnel excel, avec des duplicates Erreur d'object requirejse dans Workbook_Open avec For loop Impossible de supprimer les marques de mise en forme de l'espace caché Déployer une list élargie organisée basée sur des données compactes dans Excel

Comment exporter la valeur d'un button radio vers Excel

D'accord, alors j'ai une table, certaines des colonnes de cette table ont des buttons radio, que j'ai marqué avec les valeurs 1 à 10, j'ai également un button «Exporter vers Excel» qui exporte cette table vers un file Excel, cependant, Lorsqu'il l'exporte, il exporte les valeurs de tous les buttons radio de chacune des colonnes qui possèdent des buttons radio, je veux simplement que l'export de la valeur du button radio sélectionné dans chaque colonne, et non les valeurs de tous les buttons radio de chaque column, oh et BTW, le button "Exporter vers Excel" ne fonctionne pas dans l'aperçu dans le Déploiement de stack, donc vous devrez simplement copyr le code si vous voulez que cela fonctionne et l'save en tant que programme sur votre disque dur, de toute façon Voici mon code, merci pour votre time d'essayer de résoudre ce problème: 

var overall= $('#overall'); $(document).ready(function() { $(':radio').change(function() { var row = $(this).closest('.item'); var checkedItems = row.find(":checked") if (checkedItems.length == 6) { row.find("td.overall").html(getOverall(checkedItems)); } }) function getOverall(_checkedItems) { var total = 0; _checkedItems.each(function() { total += parseFloat($(this).val()); }); return total; } }); 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)) } })() 
 table { font-family: arial, sans-serif; border-collapse: collapse; width: 115%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 5px; text-align: center } tr:nth-child(even) { background-color: #dddddd; } div { padding-top: 10px; } collapsus frontalier: effondrement; table { font-family: arial, sans-serif; border-collapse: collapse; width: 115%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 5px; text-align: center } tr:nth-child(even) { background-color: #dddddd; } div { padding-top: 10px; } rembourrage: 5px; table { font-family: arial, sans-serif; border-collapse: collapse; width: 115%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 5px; text-align: center } tr:nth-child(even) { background-color: #dddddd; } div { padding-top: 10px; } padding-top: 10px; table { font-family: arial, sans-serif; border-collapse: collapse; width: 115%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 5px; text-align: center } tr:nth-child(even) { background-color: #dddddd; } div { padding-top: 10px; } 
 <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <table id="copyTable"> <thead> <tr> <th>Team</th> <th>Player</th> <th>Number</th> <th>Skating</th> <th>Shooting</th> <th>Passing</th> <th>Puck Control</th> <th>Team Play</th> <th>Attendance</th> <th>Overall</th> </tr> </thead> <tbody> <tr class="item" data-id="1"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1">1 <input type="radio" name="skating" value="2">2 <input type="radio" name="skating" value="3">3 <input type="radio" name="skating" value="4">4 <input type="radio" name="skating" value="5">5 <br> <input type="radio" name="skating" value="6">6 <input type="radio" name="skating" value="7">7 <input type="radio" name="skating" value="8">8 <input type="radio" name="skating" value="9">9 <input type="radio" name="skating" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1">1 <input type="radio" name="shooting" value="2">2 <input type="radio" name="shooting" value="3">3 <input type="radio" name="shooting" value="4">4 <input type="radio" name="shooting" value="5">5 <br> <input type="radio" name="shooting" value="6">6 <input type="radio" name="shooting" value="7">7 <input type="radio" name="shooting" value="8">8 <input type="radio" name="shooting" value="9">9 <input type="radio" name="shooting" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1">1 <input type="radio" name="passing" value="2">2 <input type="radio" name="passing" value="3">3 <input type="radio" name="passing" value="4">4 <input type="radio" name="passing" value="5">5 <br> <input type="radio" name="passing" value="6">6 <input type="radio" name="passing" value="7">7 <input type="radio" name="passing" value="8">8 <input type="radio" name="passing" value="9">9 <input type="radio" name="passing" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1">1 <input type="radio" name="puck_control" value="2">2 <input type="radio" name="puck_control" value="3">3 <input type="radio" name="puck_control" value="4">4 <input type="radio" name="puck_control" value="5">5 <br> <input type="radio" name="puck_control" value="6">6 <input type="radio" name="puck_control" value="7">7 <input type="radio" name="puck_control" value="8">8 <input type="radio" name="puck_control" value="9">9 <input type="radio" name="puck_control" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1">1 <input type="radio" name="team_play" value="2">2 <input type="radio" name="team_play" value="3">3 <input type="radio" name="team_play" value="4">4 <input type="radio" name="team_play" value="5">5 <br> <input type="radio" name="team_play" value="6">6 <input type="radio" name="team_play" value="7">7 <input type="radio" name="team_play" value="8">8 <input type="radio" name="team_play" value="9">9 <input type="radio" name="team_play" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1">1 <input type="radio" name="attendance" value="2">2 <input type="radio" name="attendance" value="3">3 <input type="radio" name="attendance" value="4">4 <input type="radio" name="attendance" value="5">5 <br> <input type="radio" name="attendance" value="6">6 <input type="radio" name="attendance" value="7">7 <input type="radio" name="attendance" value="8">8 <input type="radio" name="attendance" value="9">9 <input type="radio" name="attendance" value="10">10 </form> </td> <td class="overall" id="overall"> </td> </tr> <tr class="item" data-id="2"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1">1 <input type="radio" name="skating" value="2">2 <input type="radio" name="skating" value="3">3 <input type="radio" name="skating" value="4">4 <input type="radio" name="skating" value="5">5 <br> <input type="radio" name="skating" value="6">6 <input type="radio" name="skating" value="7">7 <input type="radio" name="skating" value="8">8 <input type="radio" name="skating" value="9">9 <input type="radio" name="skating" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1">1 <input type="radio" name="shooting" value="2">2 <input type="radio" name="shooting" value="3">3 <input type="radio" name="shooting" value="4">4 <input type="radio" name="shooting" value="5">5 <br> <input type="radio" name="shooting" value="6">6 <input type="radio" name="shooting" value="7">7 <input type="radio" name="shooting" value="8">8 <input type="radio" name="shooting" value="9">9 <input type="radio" name="shooting" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1">1 <input type="radio" name="passing" value="2">2 <input type="radio" name="passing" value="3">3 <input type="radio" name="passing" value="4">4 <input type="radio" name="passing" value="5">5 <br> <input type="radio" name="passing" value="6">6 <input type="radio" name="passing" value="7">7 <input type="radio" name="passing" value="8">8 <input type="radio" name="passing" value="9">9 <input type="radio" name="passing" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1">1 <input type="radio" name="puck_control" value="2">2 <input type="radio" name="puck_control" value="3">3 <input type="radio" name="puck_control" value="4">4 <input type="radio" name="puck_control" value="5">5 <br> <input type="radio" name="puck_control" value="6">6 <input type="radio" name="puck_control" value="7">7 <input type="radio" name="puck_control" value="8">8 <input type="radio" name="puck_control" value="9">9 <input type="radio" name="puck_control" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1">1 <input type="radio" name="team_play" value="2">2 <input type="radio" name="team_play" value="3">3 <input type="radio" name="team_play" value="4">4 <input type="radio" name="team_play" value="5">5 <br> <input type="radio" name="team_play" value="6">6 <input type="radio" name="team_play" value="7">7 <input type="radio" name="team_play" value="8">8 <input type="radio" name="team_play" value="9">9 <input type="radio" name="team_play" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1">1 <input type="radio" name="attendance" value="2">2 <input type="radio" name="attendance" value="3">3 <input type="radio" name="attendance" value="4">4 <input type="radio" name="attendance" value="5">5 <br> <input type="radio" name="attendance" value="6">6 <input type="radio" name="attendance" value="7">7 <input type="radio" name="attendance" value="8">8 <input type="radio" name="attendance" value="9">9 <input type="radio" name="attendance" value="10">10 </form> </td> <td class="overall" id="overall"> </td> </tr> </tbody> </table> <div align="center"> <input type="button" onclick="tableToExcel('copyTable')" value="Export to Excel"> </div> <thead> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <table id="copyTable"> <thead> <tr> <th>Team</th> <th>Player</th> <th>Number</th> <th>Skating</th> <th>Shooting</th> <th>Passing</th> <th>Puck Control</th> <th>Team Play</th> <th>Attendance</th> <th>Overall</th> </tr> </thead> <tbody> <tr class="item" data-id="1"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1">1 <input type="radio" name="skating" value="2">2 <input type="radio" name="skating" value="3">3 <input type="radio" name="skating" value="4">4 <input type="radio" name="skating" value="5">5 <br> <input type="radio" name="skating" value="6">6 <input type="radio" name="skating" value="7">7 <input type="radio" name="skating" value="8">8 <input type="radio" name="skating" value="9">9 <input type="radio" name="skating" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1">1 <input type="radio" name="shooting" value="2">2 <input type="radio" name="shooting" value="3">3 <input type="radio" name="shooting" value="4">4 <input type="radio" name="shooting" value="5">5 <br> <input type="radio" name="shooting" value="6">6 <input type="radio" name="shooting" value="7">7 <input type="radio" name="shooting" value="8">8 <input type="radio" name="shooting" value="9">9 <input type="radio" name="shooting" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1">1 <input type="radio" name="passing" value="2">2 <input type="radio" name="passing" value="3">3 <input type="radio" name="passing" value="4">4 <input type="radio" name="passing" value="5">5 <br> <input type="radio" name="passing" value="6">6 <input type="radio" name="passing" value="7">7 <input type="radio" name="passing" value="8">8 <input type="radio" name="passing" value="9">9 <input type="radio" name="passing" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1">1 <input type="radio" name="puck_control" value="2">2 <input type="radio" name="puck_control" value="3">3 <input type="radio" name="puck_control" value="4">4 <input type="radio" name="puck_control" value="5">5 <br> <input type="radio" name="puck_control" value="6">6 <input type="radio" name="puck_control" value="7">7 <input type="radio" name="puck_control" value="8">8 <input type="radio" name="puck_control" value="9">9 <input type="radio" name="puck_control" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1">1 <input type="radio" name="team_play" value="2">2 <input type="radio" name="team_play" value="3">3 <input type="radio" name="team_play" value="4">4 <input type="radio" name="team_play" value="5">5 <br> <input type="radio" name="team_play" value="6">6 <input type="radio" name="team_play" value="7">7 <input type="radio" name="team_play" value="8">8 <input type="radio" name="team_play" value="9">9 <input type="radio" name="team_play" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1">1 <input type="radio" name="attendance" value="2">2 <input type="radio" name="attendance" value="3">3 <input type="radio" name="attendance" value="4">4 <input type="radio" name="attendance" value="5">5 <br> <input type="radio" name="attendance" value="6">6 <input type="radio" name="attendance" value="7">7 <input type="radio" name="attendance" value="8">8 <input type="radio" name="attendance" value="9">9 <input type="radio" name="attendance" value="10">10 </form> </td> <td class="overall" id="overall"> </td> </tr> <tr class="item" data-id="2"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1">1 <input type="radio" name="skating" value="2">2 <input type="radio" name="skating" value="3">3 <input type="radio" name="skating" value="4">4 <input type="radio" name="skating" value="5">5 <br> <input type="radio" name="skating" value="6">6 <input type="radio" name="skating" value="7">7 <input type="radio" name="skating" value="8">8 <input type="radio" name="skating" value="9">9 <input type="radio" name="skating" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1">1 <input type="radio" name="shooting" value="2">2 <input type="radio" name="shooting" value="3">3 <input type="radio" name="shooting" value="4">4 <input type="radio" name="shooting" value="5">5 <br> <input type="radio" name="shooting" value="6">6 <input type="radio" name="shooting" value="7">7 <input type="radio" name="shooting" value="8">8 <input type="radio" name="shooting" value="9">9 <input type="radio" name="shooting" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1">1 <input type="radio" name="passing" value="2">2 <input type="radio" name="passing" value="3">3 <input type="radio" name="passing" value="4">4 <input type="radio" name="passing" value="5">5 <br> <input type="radio" name="passing" value="6">6 <input type="radio" name="passing" value="7">7 <input type="radio" name="passing" value="8">8 <input type="radio" name="passing" value="9">9 <input type="radio" name="passing" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1">1 <input type="radio" name="puck_control" value="2">2 <input type="radio" name="puck_control" value="3">3 <input type="radio" name="puck_control" value="4">4 <input type="radio" name="puck_control" value="5">5 <br> <input type="radio" name="puck_control" value="6">6 <input type="radio" name="puck_control" value="7">7 <input type="radio" name="puck_control" value="8">8 <input type="radio" name="puck_control" value="9">9 <input type="radio" name="puck_control" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1">1 <input type="radio" name="team_play" value="2">2 <input type="radio" name="team_play" value="3">3 <input type="radio" name="team_play" value="4">4 <input type="radio" name="team_play" value="5">5 <br> <input type="radio" name="team_play" value="6">6 <input type="radio" name="team_play" value="7">7 <input type="radio" name="team_play" value="8">8 <input type="radio" name="team_play" value="9">9 <input type="radio" name="team_play" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1">1 <input type="radio" name="attendance" value="2">2 <input type="radio" name="attendance" value="3">3 <input type="radio" name="attendance" value="4">4 <input type="radio" name="attendance" value="5">5 <br> <input type="radio" name="attendance" value="6">6 <input type="radio" name="attendance" value="7">7 <input type="radio" name="attendance" value="8">8 <input type="radio" name="attendance" value="9">9 <input type="radio" name="attendance" value="10">10 </form> </td> <td class="overall" id="overall"> </td> </tr> </tbody> </table> <div align="center"> <input type="button" onclick="tableToExcel('copyTable')" value="Export to Excel"> </div> <th> Number </ th> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <table id="copyTable"> <thead> <tr> <th>Team</th> <th>Player</th> <th>Number</th> <th>Skating</th> <th>Shooting</th> <th>Passing</th> <th>Puck Control</th> <th>Team Play</th> <th>Attendance</th> <th>Overall</th> </tr> </thead> <tbody> <tr class="item" data-id="1"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1">1 <input type="radio" name="skating" value="2">2 <input type="radio" name="skating" value="3">3 <input type="radio" name="skating" value="4">4 <input type="radio" name="skating" value="5">5 <br> <input type="radio" name="skating" value="6">6 <input type="radio" name="skating" value="7">7 <input type="radio" name="skating" value="8">8 <input type="radio" name="skating" value="9">9 <input type="radio" name="skating" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1">1 <input type="radio" name="shooting" value="2">2 <input type="radio" name="shooting" value="3">3 <input type="radio" name="shooting" value="4">4 <input type="radio" name="shooting" value="5">5 <br> <input type="radio" name="shooting" value="6">6 <input type="radio" name="shooting" value="7">7 <input type="radio" name="shooting" value="8">8 <input type="radio" name="shooting" value="9">9 <input type="radio" name="shooting" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1">1 <input type="radio" name="passing" value="2">2 <input type="radio" name="passing" value="3">3 <input type="radio" name="passing" value="4">4 <input type="radio" name="passing" value="5">5 <br> <input type="radio" name="passing" value="6">6 <input type="radio" name="passing" value="7">7 <input type="radio" name="passing" value="8">8 <input type="radio" name="passing" value="9">9 <input type="radio" name="passing" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1">1 <input type="radio" name="puck_control" value="2">2 <input type="radio" name="puck_control" value="3">3 <input type="radio" name="puck_control" value="4">4 <input type="radio" name="puck_control" value="5">5 <br> <input type="radio" name="puck_control" value="6">6 <input type="radio" name="puck_control" value="7">7 <input type="radio" name="puck_control" value="8">8 <input type="radio" name="puck_control" value="9">9 <input type="radio" name="puck_control" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1">1 <input type="radio" name="team_play" value="2">2 <input type="radio" name="team_play" value="3">3 <input type="radio" name="team_play" value="4">4 <input type="radio" name="team_play" value="5">5 <br> <input type="radio" name="team_play" value="6">6 <input type="radio" name="team_play" value="7">7 <input type="radio" name="team_play" value="8">8 <input type="radio" name="team_play" value="9">9 <input type="radio" name="team_play" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1">1 <input type="radio" name="attendance" value="2">2 <input type="radio" name="attendance" value="3">3 <input type="radio" name="attendance" value="4">4 <input type="radio" name="attendance" value="5">5 <br> <input type="radio" name="attendance" value="6">6 <input type="radio" name="attendance" value="7">7 <input type="radio" name="attendance" value="8">8 <input type="radio" name="attendance" value="9">9 <input type="radio" name="attendance" value="10">10 </form> </td> <td class="overall" id="overall"> </td> </tr> <tr class="item" data-id="2"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1">1 <input type="radio" name="skating" value="2">2 <input type="radio" name="skating" value="3">3 <input type="radio" name="skating" value="4">4 <input type="radio" name="skating" value="5">5 <br> <input type="radio" name="skating" value="6">6 <input type="radio" name="skating" value="7">7 <input type="radio" name="skating" value="8">8 <input type="radio" name="skating" value="9">9 <input type="radio" name="skating" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1">1 <input type="radio" name="shooting" value="2">2 <input type="radio" name="shooting" value="3">3 <input type="radio" name="shooting" value="4">4 <input type="radio" name="shooting" value="5">5 <br> <input type="radio" name="shooting" value="6">6 <input type="radio" name="shooting" value="7">7 <input type="radio" name="shooting" value="8">8 <input type="radio" name="shooting" value="9">9 <input type="radio" name="shooting" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1">1 <input type="radio" name="passing" value="2">2 <input type="radio" name="passing" value="3">3 <input type="radio" name="passing" value="4">4 <input type="radio" name="passing" value="5">5 <br> <input type="radio" name="passing" value="6">6 <input type="radio" name="passing" value="7">7 <input type="radio" name="passing" value="8">8 <input type="radio" name="passing" value="9">9 <input type="radio" name="passing" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1">1 <input type="radio" name="puck_control" value="2">2 <input type="radio" name="puck_control" value="3">3 <input type="radio" name="puck_control" value="4">4 <input type="radio" name="puck_control" value="5">5 <br> <input type="radio" name="puck_control" value="6">6 <input type="radio" name="puck_control" value="7">7 <input type="radio" name="puck_control" value="8">8 <input type="radio" name="puck_control" value="9">9 <input type="radio" name="puck_control" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1">1 <input type="radio" name="team_play" value="2">2 <input type="radio" name="team_play" value="3">3 <input type="radio" name="team_play" value="4">4 <input type="radio" name="team_play" value="5">5 <br> <input type="radio" name="team_play" value="6">6 <input type="radio" name="team_play" value="7">7 <input type="radio" name="team_play" value="8">8 <input type="radio" name="team_play" value="9">9 <input type="radio" name="team_play" value="10">10 </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1">1 <input type="radio" name="attendance" value="2">2 <input type="radio" name="attendance" value="3">3 <input type="radio" name="attendance" value="4">4 <input type="radio" name="attendance" value="5">5 <br> <input type="radio" name="attendance" value="6">6 <input type="radio" name="attendance" value="7">7 <input type="radio" name="attendance" value="8">8 <input type="radio" name="attendance" value="9">9 <input type="radio" name="attendance" value="10">10 </form> </td> <td class="overall" id="overall"> </td> </tr> </tbody> </table> <div align="center"> <input type="button" onclick="tableToExcel('copyTable')" value="Export to Excel"> </div>

C'est un petit hack, mais je pense que je l'ai travaillé. Notez que j'ai enveloppé le text après l'input de la radio dans une span

ce que j'ai fait était de cloner la table à une division cachée, supprimer tous les buttons radio non contrôlés, puis l'utiliser pour le file excel, puis supprimer l'élément clone 

 var overall = $('#overall'); $(document).ready(function() { $(':radio').change(function() { var row = $(this).closest('.item'); var checkedItems = row.find(":checked") if (checkedItems.length == 6) { row.find("td.overall").html(getOverall(checkedItems)); } }) function getOverall(_checkedItems) { var total = 0; _checkedItems.each(function() { total += parseFloat($(this).val()); }); return total; } }); 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 cloned = $('#copyTable').clone().appendTo('.hidden_table') cloned.find('input[type="radio"]:not(:checked) + span').remove(); var ctx = { worksheet: name || 'Worksheet', table: cloned.html() } cloned.remove(); window.location.href = uri + base64(format(template, ctx)) } })(); }) var overall = $('#overall'); $(document).ready(function() { $(':radio').change(function() { var row = $(this).closest('.item'); var checkedItems = row.find(":checked") if (checkedItems.length == 6) { row.find("td.overall").html(getOverall(checkedItems)); } }) function getOverall(_checkedItems) { var total = 0; _checkedItems.each(function() { total += parseFloat($(this).val()); }); return total; } }); 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 cloned = $('#copyTable').clone().appendTo('.hidden_table') cloned.find('input[type="radio"]:not(:checked) + span').remove(); var ctx = { worksheet: name || 'Worksheet', table: cloned.html() } cloned.remove(); window.location.href = uri + base64(format(template, ctx)) } })(); }, var overall = $('#overall'); $(document).ready(function() { $(':radio').change(function() { var row = $(this).closest('.item'); var checkedItems = row.find(":checked") if (checkedItems.length == 6) { row.find("td.overall").html(getOverall(checkedItems)); } }) function getOverall(_checkedItems) { var total = 0; _checkedItems.each(function() { total += parseFloat($(this).val()); }); return total; } }); 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 cloned = $('#copyTable').clone().appendTo('.hidden_table') cloned.find('input[type="radio"]:not(:checked) + span').remove(); var ctx = { worksheet: name || 'Worksheet', table: cloned.html() } cloned.remove(); window.location.href = uri + base64(format(template, ctx)) } })(); }) var overall = $('#overall'); $(document).ready(function() { $(':radio').change(function() { var row = $(this).closest('.item'); var checkedItems = row.find(":checked") if (checkedItems.length == 6) { row.find("td.overall").html(getOverall(checkedItems)); } }) function getOverall(_checkedItems) { var total = 0; _checkedItems.each(function() { total += parseFloat($(this).val()); }); return total; } }); 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 cloned = $('#copyTable').clone().appendTo('.hidden_table') cloned.find('input[type="radio"]:not(:checked) + span').remove(); var ctx = { worksheet: name || 'Worksheet', table: cloned.html() } cloned.remove(); window.location.href = uri + base64(format(template, ctx)) } })(); 
 table { font-family: arial, sans-serif; border-collapse: collapse; width: 115%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 5px; text-align: center } tr:nth-child(even) { background-color: #dddddd; } div { padding-top: 10px; } .hidden_table{ /*display:none*/ } collapsus frontalier: effondrement; table { font-family: arial, sans-serif; border-collapse: collapse; width: 115%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 5px; text-align: center } tr:nth-child(even) { background-color: #dddddd; } div { padding-top: 10px; } .hidden_table{ /*display:none*/ } rembourrage: 5px; table { font-family: arial, sans-serif; border-collapse: collapse; width: 115%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 5px; text-align: center } tr:nth-child(even) { background-color: #dddddd; } div { padding-top: 10px; } .hidden_table{ /*display:none*/ } padding-top: 10px; table { font-family: arial, sans-serif; border-collapse: collapse; width: 115%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 5px; text-align: center } tr:nth-child(even) { background-color: #dddddd; } div { padding-top: 10px; } .hidden_table{ /*display:none*/ } 
 <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <table id="copyTable"> <thead> <tr> <th>Team</th> <th>Player</th> <th>Number</th> <th>Skating</th> <th>Shooting</th> <th>Passing</th> <th>Puck Control</th> <th>Team Play</th> <th>Attendance</th> <th>Overall</th> </tr> </thead> <tbody> <tr class="item" data-id="1"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1"><span>1</span> <input type="radio" name="skating" value="2"><span>2</span> <input type="radio" name="skating" value="3"><span>3</span> <input type="radio" name="skating" value="4"><span>4</span> <input type="radio" name="skating" value="5"><span>5</span> <br> <input type="radio" name="skating" value="6"><span>6</span> <input type="radio" name="skating" value="7"><span>7</span> <input type="radio" name="skating" value="8"><span>8</span> <input type="radio" name="skating" value="9"><span>9</span> <input type="radio" name="skating" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1"><span>1</span> <input type="radio" name="shooting" value="2"><span>2</span> <input type="radio" name="shooting" value="3"><span>3</span> <input type="radio" name="shooting" value="4"><span>4</span> <input type="radio" name="shooting" value="5"><span>5</span> <br> <input type="radio" name="shooting" value="6"><span>6</span> <input type="radio" name="shooting" value="7"><span>7</span> <input type="radio" name="shooting" value="8"><span>8</span> <input type="radio" name="shooting" value="9"><span>9</span> <input type="radio" name="shooting" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1"><span>1</span> <input type="radio" name="passing" value="2"><span>2</span> <input type="radio" name="passing" value="3"><span>3</span> <input type="radio" name="passing" value="4"><span>4</span> <input type="radio" name="passing" value="5"><span>5</span> <br> <input type="radio" name="passing" value="6"><span>6</span> <input type="radio" name="passing" value="7"><span>7</span> <input type="radio" name="passing" value="8"><span>8</span> <input type="radio" name="passing" value="9"><span>9</span> <input type="radio" name="passing" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1"><span>1</span> <input type="radio" name="puck_control" value="2"><span>2</span> <input type="radio" name="puck_control" value="3"><span>3</span> <input type="radio" name="puck_control" value="4"><span>4</span> <input type="radio" name="puck_control" value="5"><span>5</span> <br> <input type="radio" name="puck_control" value="6"><span>6</span> <input type="radio" name="puck_control" value="7"><span>7</span> <input type="radio" name="puck_control" value="8"><span>8</span> <input type="radio" name="puck_control" value="9"><span>9</span> <input type="radio" name="puck_control" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1"><span>1</span> <input type="radio" name="team_play" value="2"><span>2</span> <input type="radio" name="team_play" value="3"><span>3</span> <input type="radio" name="team_play" value="4"><span>4</span> <input type="radio" name="team_play" value="5"><span>5</span> <br> <input type="radio" name="team_play" value="6"><span>6</span> <input type="radio" name="team_play" value="7"><span>7</span> <input type="radio" name="team_play" value="8"><span>8</span> <input type="radio" name="team_play" value="9"><span>9</span> <input type="radio" name="team_play" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1"><span>1</span> <input type="radio" name="attendance" value="2"><span>2</span> <input type="radio" name="attendance" value="3"><span>3</span> <input type="radio" name="attendance" value="4"><span>4</span> <input type="radio" name="attendance" value="5"><span>5</span> <br> <input type="radio" name="attendance" value="6"><span>6</span> <input type="radio" name="attendance" value="7"><span>7</span> <input type="radio" name="attendance" value="8"><span>8</span> <input type="radio" name="attendance" value="9"><span>9</span> <input type="radio" name="attendance" value="10"><span>10</span> </form> </td> <td class="overall" id="overall"> </td> </tr> <tr class="item" data-id="2"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1"><span>1</span> <input type="radio" name="skating" value="2"><span>2</span> <input type="radio" name="skating" value="3"><span>3</span> <input type="radio" name="skating" value="4"><span>4</span> <input type="radio" name="skating" value="5"><span>5</span> <br> <input type="radio" name="skating" value="6"><span>6</span> <input type="radio" name="skating" value="7"><span>7</span> <input type="radio" name="skating" value="8"><span>8</span> <input type="radio" name="skating" value="9"><span>9</span> <input type="radio" name="skating" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1"><span>1</span> <input type="radio" name="shooting" value="2"><span>2</span> <input type="radio" name="shooting" value="3"><span>3</span> <input type="radio" name="shooting" value="4"><span>4</span> <input type="radio" name="shooting" value="5"><span>5</span> <br> <input type="radio" name="shooting" value="6"><span>6</span> <input type="radio" name="shooting" value="7"><span>7</span> <input type="radio" name="shooting" value="8"><span>8</span> <input type="radio" name="shooting" value="9"><span>9</span> <input type="radio" name="shooting" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1"><span>1</span> <input type="radio" name="passing" value="2"><span>2</span> <input type="radio" name="passing" value="3"><span>3</span> <input type="radio" name="passing" value="4"><span>4</span> <input type="radio" name="passing" value="5"><span>5</span> <br> <input type="radio" name="passing" value="6"><span>6</span> <input type="radio" name="passing" value="7"><span>7</span> <input type="radio" name="passing" value="8"><span>8</span> <input type="radio" name="passing" value="9"><span>9</span> <input type="radio" name="passing" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1"><span>1</span> <input type="radio" name="puck_control" value="2"><span>2</span> <input type="radio" name="puck_control" value="3"><span>3</span> <input type="radio" name="puck_control" value="4"><span>4</span> <input type="radio" name="puck_control" value="5"><span>5</span> <br> <input type="radio" name="puck_control" value="6"><span>6</span> <input type="radio" name="puck_control" value="7"><span>7</span> <input type="radio" name="puck_control" value="8"><span>8</span> <input type="radio" name="puck_control" value="9"><span>9</span> <input type="radio" name="puck_control" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1"><span>1</span> <input type="radio" name="team_play" value="2"><span>2</span> <input type="radio" name="team_play" value="3"><span>3</span> <input type="radio" name="team_play" value="4"><span>4</span> <input type="radio" name="team_play" value="5"><span>5</span> <br> <input type="radio" name="team_play" value="6"><span>6</span> <input type="radio" name="team_play" value="7"><span>7</span> <input type="radio" name="team_play" value="8"><span>8</span> <input type="radio" name="team_play" value="9"><span>9</span> <input type="radio" name="team_play" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1"><span>1</span> <input type="radio" name="attendance" value="2"><span>2</span> <input type="radio" name="attendance" value="3"><span>3</span> <input type="radio" name="attendance" value="4"><span>4</span> <input type="radio" name="attendance" value="5"><span>5</span> <br> <input type="radio" name="attendance" value="6"><span>6</span> <input type="radio" name="attendance" value="7"><span>7</span> <input type="radio" name="attendance" value="8"><span>8</span> <input type="radio" name="attendance" value="9"><span>9</span> <input type="radio" name="attendance" value="10"><span>10</span> </form> </td> <td class="overall" id="overall"> </td> </tr> </tbody> </table> <div class="hidden_table" id="hidden_table"></div> <div align="center"> <input type="button" onclick="tableToExcel('copyTable', 'Player_scores')" value="Export to Excel"> </div> <thead> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <table id="copyTable"> <thead> <tr> <th>Team</th> <th>Player</th> <th>Number</th> <th>Skating</th> <th>Shooting</th> <th>Passing</th> <th>Puck Control</th> <th>Team Play</th> <th>Attendance</th> <th>Overall</th> </tr> </thead> <tbody> <tr class="item" data-id="1"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1"><span>1</span> <input type="radio" name="skating" value="2"><span>2</span> <input type="radio" name="skating" value="3"><span>3</span> <input type="radio" name="skating" value="4"><span>4</span> <input type="radio" name="skating" value="5"><span>5</span> <br> <input type="radio" name="skating" value="6"><span>6</span> <input type="radio" name="skating" value="7"><span>7</span> <input type="radio" name="skating" value="8"><span>8</span> <input type="radio" name="skating" value="9"><span>9</span> <input type="radio" name="skating" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1"><span>1</span> <input type="radio" name="shooting" value="2"><span>2</span> <input type="radio" name="shooting" value="3"><span>3</span> <input type="radio" name="shooting" value="4"><span>4</span> <input type="radio" name="shooting" value="5"><span>5</span> <br> <input type="radio" name="shooting" value="6"><span>6</span> <input type="radio" name="shooting" value="7"><span>7</span> <input type="radio" name="shooting" value="8"><span>8</span> <input type="radio" name="shooting" value="9"><span>9</span> <input type="radio" name="shooting" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1"><span>1</span> <input type="radio" name="passing" value="2"><span>2</span> <input type="radio" name="passing" value="3"><span>3</span> <input type="radio" name="passing" value="4"><span>4</span> <input type="radio" name="passing" value="5"><span>5</span> <br> <input type="radio" name="passing" value="6"><span>6</span> <input type="radio" name="passing" value="7"><span>7</span> <input type="radio" name="passing" value="8"><span>8</span> <input type="radio" name="passing" value="9"><span>9</span> <input type="radio" name="passing" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1"><span>1</span> <input type="radio" name="puck_control" value="2"><span>2</span> <input type="radio" name="puck_control" value="3"><span>3</span> <input type="radio" name="puck_control" value="4"><span>4</span> <input type="radio" name="puck_control" value="5"><span>5</span> <br> <input type="radio" name="puck_control" value="6"><span>6</span> <input type="radio" name="puck_control" value="7"><span>7</span> <input type="radio" name="puck_control" value="8"><span>8</span> <input type="radio" name="puck_control" value="9"><span>9</span> <input type="radio" name="puck_control" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1"><span>1</span> <input type="radio" name="team_play" value="2"><span>2</span> <input type="radio" name="team_play" value="3"><span>3</span> <input type="radio" name="team_play" value="4"><span>4</span> <input type="radio" name="team_play" value="5"><span>5</span> <br> <input type="radio" name="team_play" value="6"><span>6</span> <input type="radio" name="team_play" value="7"><span>7</span> <input type="radio" name="team_play" value="8"><span>8</span> <input type="radio" name="team_play" value="9"><span>9</span> <input type="radio" name="team_play" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1"><span>1</span> <input type="radio" name="attendance" value="2"><span>2</span> <input type="radio" name="attendance" value="3"><span>3</span> <input type="radio" name="attendance" value="4"><span>4</span> <input type="radio" name="attendance" value="5"><span>5</span> <br> <input type="radio" name="attendance" value="6"><span>6</span> <input type="radio" name="attendance" value="7"><span>7</span> <input type="radio" name="attendance" value="8"><span>8</span> <input type="radio" name="attendance" value="9"><span>9</span> <input type="radio" name="attendance" value="10"><span>10</span> </form> </td> <td class="overall" id="overall"> </td> </tr> <tr class="item" data-id="2"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1"><span>1</span> <input type="radio" name="skating" value="2"><span>2</span> <input type="radio" name="skating" value="3"><span>3</span> <input type="radio" name="skating" value="4"><span>4</span> <input type="radio" name="skating" value="5"><span>5</span> <br> <input type="radio" name="skating" value="6"><span>6</span> <input type="radio" name="skating" value="7"><span>7</span> <input type="radio" name="skating" value="8"><span>8</span> <input type="radio" name="skating" value="9"><span>9</span> <input type="radio" name="skating" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1"><span>1</span> <input type="radio" name="shooting" value="2"><span>2</span> <input type="radio" name="shooting" value="3"><span>3</span> <input type="radio" name="shooting" value="4"><span>4</span> <input type="radio" name="shooting" value="5"><span>5</span> <br> <input type="radio" name="shooting" value="6"><span>6</span> <input type="radio" name="shooting" value="7"><span>7</span> <input type="radio" name="shooting" value="8"><span>8</span> <input type="radio" name="shooting" value="9"><span>9</span> <input type="radio" name="shooting" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1"><span>1</span> <input type="radio" name="passing" value="2"><span>2</span> <input type="radio" name="passing" value="3"><span>3</span> <input type="radio" name="passing" value="4"><span>4</span> <input type="radio" name="passing" value="5"><span>5</span> <br> <input type="radio" name="passing" value="6"><span>6</span> <input type="radio" name="passing" value="7"><span>7</span> <input type="radio" name="passing" value="8"><span>8</span> <input type="radio" name="passing" value="9"><span>9</span> <input type="radio" name="passing" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1"><span>1</span> <input type="radio" name="puck_control" value="2"><span>2</span> <input type="radio" name="puck_control" value="3"><span>3</span> <input type="radio" name="puck_control" value="4"><span>4</span> <input type="radio" name="puck_control" value="5"><span>5</span> <br> <input type="radio" name="puck_control" value="6"><span>6</span> <input type="radio" name="puck_control" value="7"><span>7</span> <input type="radio" name="puck_control" value="8"><span>8</span> <input type="radio" name="puck_control" value="9"><span>9</span> <input type="radio" name="puck_control" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1"><span>1</span> <input type="radio" name="team_play" value="2"><span>2</span> <input type="radio" name="team_play" value="3"><span>3</span> <input type="radio" name="team_play" value="4"><span>4</span> <input type="radio" name="team_play" value="5"><span>5</span> <br> <input type="radio" name="team_play" value="6"><span>6</span> <input type="radio" name="team_play" value="7"><span>7</span> <input type="radio" name="team_play" value="8"><span>8</span> <input type="radio" name="team_play" value="9"><span>9</span> <input type="radio" name="team_play" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1"><span>1</span> <input type="radio" name="attendance" value="2"><span>2</span> <input type="radio" name="attendance" value="3"><span>3</span> <input type="radio" name="attendance" value="4"><span>4</span> <input type="radio" name="attendance" value="5"><span>5</span> <br> <input type="radio" name="attendance" value="6"><span>6</span> <input type="radio" name="attendance" value="7"><span>7</span> <input type="radio" name="attendance" value="8"><span>8</span> <input type="radio" name="attendance" value="9"><span>9</span> <input type="radio" name="attendance" value="10"><span>10</span> </form> </td> <td class="overall" id="overall"> </td> </tr> </tbody> </table> <div class="hidden_table" id="hidden_table"></div> <div align="center"> <input type="button" onclick="tableToExcel('copyTable', 'Player_scores')" value="Export to Excel"> </div> <th> Number </ th> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <table id="copyTable"> <thead> <tr> <th>Team</th> <th>Player</th> <th>Number</th> <th>Skating</th> <th>Shooting</th> <th>Passing</th> <th>Puck Control</th> <th>Team Play</th> <th>Attendance</th> <th>Overall</th> </tr> </thead> <tbody> <tr class="item" data-id="1"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1"><span>1</span> <input type="radio" name="skating" value="2"><span>2</span> <input type="radio" name="skating" value="3"><span>3</span> <input type="radio" name="skating" value="4"><span>4</span> <input type="radio" name="skating" value="5"><span>5</span> <br> <input type="radio" name="skating" value="6"><span>6</span> <input type="radio" name="skating" value="7"><span>7</span> <input type="radio" name="skating" value="8"><span>8</span> <input type="radio" name="skating" value="9"><span>9</span> <input type="radio" name="skating" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1"><span>1</span> <input type="radio" name="shooting" value="2"><span>2</span> <input type="radio" name="shooting" value="3"><span>3</span> <input type="radio" name="shooting" value="4"><span>4</span> <input type="radio" name="shooting" value="5"><span>5</span> <br> <input type="radio" name="shooting" value="6"><span>6</span> <input type="radio" name="shooting" value="7"><span>7</span> <input type="radio" name="shooting" value="8"><span>8</span> <input type="radio" name="shooting" value="9"><span>9</span> <input type="radio" name="shooting" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1"><span>1</span> <input type="radio" name="passing" value="2"><span>2</span> <input type="radio" name="passing" value="3"><span>3</span> <input type="radio" name="passing" value="4"><span>4</span> <input type="radio" name="passing" value="5"><span>5</span> <br> <input type="radio" name="passing" value="6"><span>6</span> <input type="radio" name="passing" value="7"><span>7</span> <input type="radio" name="passing" value="8"><span>8</span> <input type="radio" name="passing" value="9"><span>9</span> <input type="radio" name="passing" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1"><span>1</span> <input type="radio" name="puck_control" value="2"><span>2</span> <input type="radio" name="puck_control" value="3"><span>3</span> <input type="radio" name="puck_control" value="4"><span>4</span> <input type="radio" name="puck_control" value="5"><span>5</span> <br> <input type="radio" name="puck_control" value="6"><span>6</span> <input type="radio" name="puck_control" value="7"><span>7</span> <input type="radio" name="puck_control" value="8"><span>8</span> <input type="radio" name="puck_control" value="9"><span>9</span> <input type="radio" name="puck_control" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1"><span>1</span> <input type="radio" name="team_play" value="2"><span>2</span> <input type="radio" name="team_play" value="3"><span>3</span> <input type="radio" name="team_play" value="4"><span>4</span> <input type="radio" name="team_play" value="5"><span>5</span> <br> <input type="radio" name="team_play" value="6"><span>6</span> <input type="radio" name="team_play" value="7"><span>7</span> <input type="radio" name="team_play" value="8"><span>8</span> <input type="radio" name="team_play" value="9"><span>9</span> <input type="radio" name="team_play" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1"><span>1</span> <input type="radio" name="attendance" value="2"><span>2</span> <input type="radio" name="attendance" value="3"><span>3</span> <input type="radio" name="attendance" value="4"><span>4</span> <input type="radio" name="attendance" value="5"><span>5</span> <br> <input type="radio" name="attendance" value="6"><span>6</span> <input type="radio" name="attendance" value="7"><span>7</span> <input type="radio" name="attendance" value="8"><span>8</span> <input type="radio" name="attendance" value="9"><span>9</span> <input type="radio" name="attendance" value="10"><span>10</span> </form> </td> <td class="overall" id="overall"> </td> </tr> <tr class="item" data-id="2"> <td></td> <td></td> <td></td> <td> <form action=""> <input type="radio" name="skating" value="1"><span>1</span> <input type="radio" name="skating" value="2"><span>2</span> <input type="radio" name="skating" value="3"><span>3</span> <input type="radio" name="skating" value="4"><span>4</span> <input type="radio" name="skating" value="5"><span>5</span> <br> <input type="radio" name="skating" value="6"><span>6</span> <input type="radio" name="skating" value="7"><span>7</span> <input type="radio" name="skating" value="8"><span>8</span> <input type="radio" name="skating" value="9"><span>9</span> <input type="radio" name="skating" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="shooting" value="1"><span>1</span> <input type="radio" name="shooting" value="2"><span>2</span> <input type="radio" name="shooting" value="3"><span>3</span> <input type="radio" name="shooting" value="4"><span>4</span> <input type="radio" name="shooting" value="5"><span>5</span> <br> <input type="radio" name="shooting" value="6"><span>6</span> <input type="radio" name="shooting" value="7"><span>7</span> <input type="radio" name="shooting" value="8"><span>8</span> <input type="radio" name="shooting" value="9"><span>9</span> <input type="radio" name="shooting" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="passing" value="1"><span>1</span> <input type="radio" name="passing" value="2"><span>2</span> <input type="radio" name="passing" value="3"><span>3</span> <input type="radio" name="passing" value="4"><span>4</span> <input type="radio" name="passing" value="5"><span>5</span> <br> <input type="radio" name="passing" value="6"><span>6</span> <input type="radio" name="passing" value="7"><span>7</span> <input type="radio" name="passing" value="8"><span>8</span> <input type="radio" name="passing" value="9"><span>9</span> <input type="radio" name="passing" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="puck_control" value="1"><span>1</span> <input type="radio" name="puck_control" value="2"><span>2</span> <input type="radio" name="puck_control" value="3"><span>3</span> <input type="radio" name="puck_control" value="4"><span>4</span> <input type="radio" name="puck_control" value="5"><span>5</span> <br> <input type="radio" name="puck_control" value="6"><span>6</span> <input type="radio" name="puck_control" value="7"><span>7</span> <input type="radio" name="puck_control" value="8"><span>8</span> <input type="radio" name="puck_control" value="9"><span>9</span> <input type="radio" name="puck_control" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="team_play" value="1"><span>1</span> <input type="radio" name="team_play" value="2"><span>2</span> <input type="radio" name="team_play" value="3"><span>3</span> <input type="radio" name="team_play" value="4"><span>4</span> <input type="radio" name="team_play" value="5"><span>5</span> <br> <input type="radio" name="team_play" value="6"><span>6</span> <input type="radio" name="team_play" value="7"><span>7</span> <input type="radio" name="team_play" value="8"><span>8</span> <input type="radio" name="team_play" value="9"><span>9</span> <input type="radio" name="team_play" value="10"><span>10</span> </form> </td> <td> <form action=""> <input type="radio" name="attendance" value="1"><span>1</span> <input type="radio" name="attendance" value="2"><span>2</span> <input type="radio" name="attendance" value="3"><span>3</span> <input type="radio" name="attendance" value="4"><span>4</span> <input type="radio" name="attendance" value="5"><span>5</span> <br> <input type="radio" name="attendance" value="6"><span>6</span> <input type="radio" name="attendance" value="7"><span>7</span> <input type="radio" name="attendance" value="8"><span>8</span> <input type="radio" name="attendance" value="9"><span>9</span> <input type="radio" name="attendance" value="10"><span>10</span> </form> </td> <td class="overall" id="overall"> </td> </tr> </tbody> </table> <div class="hidden_table" id="hidden_table"></div> <div align="center"> <input type="button" onclick="tableToExcel('copyTable', 'Player_scores')" value="Export to Excel"> </div>