我目前正在編寫(xiě)一個(gè)腳本，該腳本從 google 表格中提取數(shù)據(jù)并將其轉(zhuǎn)換為 html 表。但我的谷歌表格中有鏈接，所以我希望這些鏈接可以在一個(gè)看起來(lái)不錯(cuò)但不知道如何做到這一點(diǎn)的按鈕中獲得。我現(xiàn)在有這個(gè)loobfor (var i = 0; i < entry.length; i++) { html += '<tr>'; html += '<td>' + entry[i]['gsx$komponente']['$t'] + '</td>'; html += '<td>' + entry[i]['gsx$name']['$t'] + '</td>'; html += '<td>' + entry[i]['gsx$hersteller']['$t'] + '</td>'; html += '<td>' + entry[i]['gsx$preis']['$t'] + '</td>'; html += '<td>' + entry[i]['gsx$link']['$t'] + '</td>'; html += '</tr>'; } html += '</table>';這entry[i]['gsx$link']['$t']給了我鏈接，我只是無(wú)法讓它在按鈕內(nèi)工作如果您知道如何解決這個(gè)問(wèn)題，請(qǐng)幫助我這是完整的代碼<!DOCTYPE html><meta charset="ISO-8859-1"> <html><body><script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <script>// ID of the Google Spreadsheetvar spreadsheetID = "1Xx0qGY_5Ic1KNB7m8Lu5mZqHE4XQzauvcugTVUGwgqk"; // Make sure it is public or set to Anyone with link can view var url = "https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/od6/public/values?alt=json"; // make JSON call to Google Data API$.getJSON(url, function(data) { // set global html variable var html = ''; // build table headings html += '<table>'; html += '<tr>'; html += '<th>Komponente</th>'; html += '<th>Name</th>'; html += '<th>Hersteller</th>'; html += '<th>Preis</th>'; html += '<th>Link</th>'; html += '</tr>'; // loop to build html output for each row var entry = data.feed.entry; /** ** Change to descending order ** for (var i = entry.length - 1; i >= 0; i -= 1) { */ for (var i = 0; i < entry.length; i++) { html += '<tr>'; html += '<td>' + entry[i]['gsx$komponente']['$t'] + '</td>'; html += '<td>' + entry[i]['gsx$name']['$t'] + '</td>'; html += '<td>' + entry[i]['gsx$hersteller']['$t'] + '</td>'; html += '<td>' + entry[i]['gsx$preis']['$t'] + '</td>'; html += '<td>' + entry[i]['gsx$link']['$t'] + '</td>'; html += '</tr>'; }
如何在html href標(biāo)簽中插入鏈接
紫衣仙女
2023-06-29 22:47:38
