google-apps-script - 如何在数据中查找值，然后在 Google Apps 脚本中删除找到的列？

Question

我有一个脚本接收提示响应，搜索该值，然后删除给定的行或列。这是搜索和删除运行良好的行的脚本：

function DeleteResources() {
  var ss = SpreadsheetApp.openById("SpreadhsheetID");
  // PROMPTS USER TO INSERT TASK NAME
  var ui = SpreadsheetApp.getUi();
  var result = ui.prompt(
    'Name of Task:',
    '',
    ui.ButtonSet.OK);
  // DELETES GIVEN TASK FROM RESOURCES
  var text = result.getResponseText();
  var sheet = ss.getSheetByName("SheetName");
  var textFinder = sheet.createTextFinder(text)
  var search_row = textFinder.findNext().getRow();
  sheet.deleteRow(search_row);
};

这是搜索值并删除列的修改版本，但是这个不能正常工作：

function DeleteDailyStatisticsRaw() {
  var ss = SpreadsheetApp.openById("SpreadsheetID");
  // PROMPTS USER TO INSERT TASK NAME
  var ui = SpreadsheetApp.getUi();
  var result = ui.prompt(
    'Name of Task:',
    '',
    ui.ButtonSet.OK);
  // DELETES GIVEN TASK FROM DAILY STATISTICS RAW
  var text = result.getResponseText();
  var sheet = ss.getSheetByName("SheetName");
  var textFinder = sheet.createTextFinder(text)
  var search_column = textFinder.findNext().getColumn();
  sheet.deleteColumn(search_column);
};

感谢您的任何帮助！

标签： google-apps-script