function execute() {
var result = "";
result = GetSwagger();
ShowResult(result);
}
function ShowResult(result) {
//var showResult = Browser.msgBox(result,
// Browser.Buttons.OK);
var showResult = Browser.msgBox("書き込み完了",
Browser.Buttons.OK);
}
function GetSwagger()
{
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = spreadsheet.getActiveSheet();
var propIndent = " ";
var memberIndent = propIndent + " ";
var valueIndent = memberIndent + " ";
var headerCreateTable = propIndent + "properties: \n";
var footerCreateTable = " ";
var rowCount = GetCellValue(sheet, 1, 3);
var columnName = '';
var defineCols = '';
var colHaaderName = '';
var paramName = '';
for(i=0;i <rowCount; i++)
{
columnName = GetCellValue(sheet, (i+2), 2);
columnValue = GetCellValue(sheet, (i+2), 4);
paramName = colHaaderName + columnName
defineCols = defineCols + memberIndent + paramName + ":\n" + valueIndent + "type: string" + "\n" + valueIndent + "example: \"" + columnValue + "\"\n";
}
WriteCellValue(sheet,1,7,headerCreateTable + defineCols + footerCreateTable);
return headerCreateTable + defineCols + footerCreateTable;
}
function GetCellValue(sheet, row, column) {
var range = sheet.getRange(row, column);
return range.getValue();
}
function WriteCellValue(sheet, row, column, value) {
var range = sheet.getRange(row, column);
range.setValue(value);
}