swagger作成マクロ

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);
}