function mainmenu(){ var query = new google.visualization.Query( "https://spreadsheets.google.com/ccc?key=0Ahx8FrCtx3TOdDBuMnRJRmtyRDludGNIWVU1TEZCSWc&hl=en"); query.setQuery("select A,B"); query.send(handleQueryResponsemainmenu); } function handleQueryResponsemainmenu(response) { var data = response.getDataTable(); for (var row = 1 ; row < data.getNumberOfRows() ; row++) { //ここでは1行目はのぞく var li = $("
"); var href = $(""); href.text(data.getFormattedValue(row, 0)); var attr = (data.getFormattedValue(row, 1)=='')?data.getFormattedValue(row, 0):data.getFormattedValue(row, 1); href.attr("href",attr); li.append(href); $("ul#mainmenu").append(li); } }