テーブルのDELETE文GAS

テーブルのDELETE文GAS作った

function deleteSQL() {
  // 現在のスプレッドシートの取得
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var objSheet = spreadsheet.getSheetByName("削除シート");
  SpreadsheetApp.setActiveSheet(objSheet);

  var sheet = spreadsheet.getActiveSheet();

  var topSql = "delete from ";
  var whereSql = " where institution_code = '";
  var bottomSql = " ;"

  var tableCount = 5
  var rowCount = 3 

  for(i=0; i < tableCount; i++)
  {
    for(j=0; j < rowCount; j++)
    {
      var range = sheet.getRange((i*rowCount) + (j + 1), 6);
      range.setValue("");
      range.setValue(topSql + GetTableName(sheet, i + 6) + whereSql + GetCode(sheet, j + 6)  + "' "  + bottomSql);
    }  
  }
  Browser.msgBox("作成完了");
}


function GetTableName(sheet, row)
{
  var result = GetCellValue(sheet, row, "1");
  return result;
}

function GetCode(sheet, row)
{
  var result = GetCellValue(sheet, row, "3");
  return result;
}

function GetCodeCount(sheet)
{
  var result = GetCellValue(sheet, "6", "4");
  return result;
}

function GetTableCount(sheet)
{
  var result = GetCellValue(sheet, "6", "2");
  return result;
}

function GetCellValue(sheet, row, column) {
  var range = sheet.getRange(row, column)  
  return range.getValue();
}