¡¡¥¹¥×¥ì¥Ã¥É¥·¡¼¥ÈÆâ¤Î¥á¥Ë¥å¡¼¤è¤ê¡Ö³ÈÄ¥µ¡Ç½¡×¢ª¡ÖAppsScript¡× ¤òÁªÂò¤·¤Þ¤¹¡£
Ê̤Υ¿¥Ö¤Ç¥¹¥¯¥ê¥×¥È¤ÎÊÔ½¸¥Ú¡¼¥¸¤¬³«¤¤Þ¤¹¡£
¡¡¥Ú¡¼¥¸Æâ¤Ë¤ÏºÇ½é¤«¤é¥¹¥¯¥ê¥×¥È¥Õ¥¡¥¤¥ë¤¬£±¤ÄºîÀ®¤µ¤ì¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢
¤³¤Á¤é¤òÊÔ½¸¤·¤Æ¡¢¸½ºß³«¤¤¤Æ¤¤¤ë¥·¡¼¥È¤ÎÆâÍƤò Json ·Á¼°¤Ç½ÐÎϤ¹¤ëµ¡Ç½¤òºî¤ê¤Þ¤¹¡£
¡¡¥Õ¥¡¥¤¥ë̾¤Ï¤ï¤«¤ê¤ä¤¹¤¤Ì¾¾Î¤Ç¤¢¤ì¤Ð²¿¤Ç¤â¹½¤¤¤Þ¤»¤ó¡£
function exportToJson() {
// ¥·¡¼¥È̾¤ò»ØÄê
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1'); // 'Sheet1'¤Ï³Æ¼«¤Î¥·¡¼¥È̾¤ËÊѹ¹
// ¥Ç¡¼¥¿¤ò¼èÆÀ
var data = sheet.getDataRange().getValues();
// ¥Ø¥Ã¥À¡¼¹Ô¤ò¼èÆÀ
var headers = data[0];
// ¥Ç¡¼¥¿¤òJSON·Á¼°¤ËÊÑ´¹
var jsonData = [];
for (var i = 1; i < data.length; i++) {
var row = data[i];
var obj = {};
obj['tag'] = row[0];
// 'jp', 'kr', 'en' ¤ÎÎó¤òÇÛÎó¤Ë¤Þ¤È¤á¤ë
obj['languageDatas'] = [row[1], row[2], row[3]];
jsonData.push(obj);
}
// JSON¥Ç¡¼¥¿¤ò½ÐÎÏ
var jsonOutput = JSON.stringify(jsonData, null, 2);
Logger.log(jsonOutput);
// ¥Õ¥¡¥¤¥ë¤Ë½ñ¤¹þ¤à¾ì¹ç
// var jsonFile = DriveApp.createFile('output.json', jsonOutput, MimeType.PLAIN_TEXT);
}