Created
September 12, 2011 09:09
-
-
Save kawaz/1210888 to your computer and use it in GitHub Desktop.
#gdd11jpのAppsScript問題のコード
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
function resolveQuiz() { | |
var qs = ss.getActiveSheet(); | |
var q = qs.getRange(1, 1).getValue(); | |
try { | |
var json = JSON.parse(q); | |
} catch($e) { | |
Browser.msgBox("A1セルに問題のJSONを入力しておいて下さい"); | |
return; | |
} | |
//シートを全削除 | |
qs.setName("問題入力用"); | |
ss.getSheets().forEach(function(s){ | |
Logger.log(s.getSheetName()); | |
if(s.getName() != qs.getName()) { | |
s.activate(); | |
ss.deleteActiveSheet(); | |
} | |
}); | |
//回答シートを作成 | |
json.forEach(function(v, i){ | |
var sheet = ss.insertSheet(v.city_name); | |
v.data.forEach(function(d,i){ | |
sheet.getRange(i + 1, 1).setValue(d.capacity); | |
sheet.getRange(i + 1, 2).setValue(d.usage); | |
sheet.getRange(i + 1, 3).setFormula("=B"+(i+1)+"/A"+(i+1)); | |
sheet.getRange(i + 1, 3).setNumberFormat("##.00%"); | |
}); | |
}); | |
//問題入力用シートを削除 | |
ss.getSheetByName("問題入力用").activate(); | |
ss.deleteActiveSheet(); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment