How do you delete an image from a google sheet

Question

I would like to remove/delete an image that I inserted into a google sheet. I used the code:

sheet.insertImage(url,col,row);

to insert the image. But, I want to remove the image later in the code and insert a different image. or not have an image at all.

score 7 · Answer 1 · answered Oct 22 '18 at 14:19

Try the following:

      // Deletes all images in sheet
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      var sheet = ss.getSheetByName("Your Tab Name");
      var images = sheet.getImages();
      images.map(function(img){img.remove();});

score -1 · Answer 2 · answered Jul 03 '15 at 08:55

-1

use this code to remove your image

    function clearRange() {
  //replace 'Sheet1' with your actual sheet name
  var sheet = SpreadsheetApp.getActive().getSheetByName('Sheet1');
  sheet.getRange('B7:G7').clearContent();
}

answered Jul 03 '15 at 08:55

Hamelraj

4,676
4
19
42

I tried this and changed the range to the range where the image was inserted. But, this did not work. – user3158459 Jul 03 '15 at 14:36

score -1 · Answer 3 · answered Jan 26 '16 at 17:51

In my testing, inserting a different image, in the the same cell, simply stacks the new image over the top of the old image.

sheet.insertImage('http://somewhere.com/images/image1.png',col,row);
sheet.insertImage('http://somewhere.com/images/image2.png',col,row);

I had hoped to effectively 'remove' image1 by substituting a blank(transparent) image2. One can cover up image1 with some other opaque image. ('mask', 'overlay', 'overlap' 'conceal', 'hide')

overlapped images In my experience, theCell.clearContent() does not affect the image but will clear other cell contents.

How do you delete an image from a google sheet

3 Answers3