テーブルの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();
}