2
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

【Google App Script】 insertImageの削除の覚書

2
Last updated at Posted at 2019-06-11

英語がわからない私には全く情報を見つけられず。
マクロを頼って充てがいました。

最後の画像を削除
function del_image(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = ss.getSheetByName(sname);
  var images = s.getImages();
  var image = images[images.length - 1];
    try {
      image.remove();
    } catch(ex) {
      Logger.log("削除する画像はありません");
    }
}
シート内画像_全削除
function del_image(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = ss.getSheetByName(sname);
  var images = s.getImages();

  for (var i = 0;i < images.length;i++) {
    images[i].remove();
  }
}
2
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
2
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?