Class OverGridImage

  • OverGridImage represents an image overlaid on a spreadsheet grid, offering methods to control its properties and behavior.

  • It provides methods for manipulating the image's size, position, anchoring, alt text, and assigned script.

  • Users can replace the image, reset its size, get its URL and dimensions, and remove it from the spreadsheet.

  • Each method requires specific authorization scopes, primarily https://www.googleapis.com/auth/spreadsheets.currentonly or https://www.googleapis.com/auth/spreadsheets, to execute.
OverGridImage

Represents an image over the grid in a spreadsheet.

Methods

MethodReturn typeBrief description
assignScript(functionName) OverGridImage Assigns the function with the specified function name to this image.
getAltTextDescription() StringReturns the alt text description for this image.
getAltTextTitle() StringReturns the alt text title for this image.
getAnchorCell() Range Returns the cell where an image is anchored.
getAnchorCellXOffset() IntegerReturns the horizontal pixel offset from the anchor cell.
getAnchorCellYOffset() IntegerReturns the vertical pixel offset from the anchor cell.
getHeight() IntegerReturns the actual height of this image in pixels.
getInherentHeight() IntegerReturns the inherent height of this image in pixels.
getInherentWidth() IntegerReturns the inherent height of this image in pixels.
getScript() StringReturns the name of the function assigned to this image.
getSheet() Sheet Returns the sheet this image appears on.
getWidth() IntegerReturns the actual width of this image in pixels.
remove() voidDeletes this image from the spreadsheet.
replace(blob) OverGridImage Replaces this image with the one specified by the provided BlobSource .
replace(url) OverGridImage Replaces this image with the one from the specified URL.
resetSize() OverGridImage Resets this image to its inherent dimensions.
setAltTextDescription(description) OverGridImage Sets the alt-text description for this image.
setAltTextTitle(title) OverGridImage Sets the alt text title for this image.
setAnchorCell(cell) OverGridImage Sets the cell where an image is anchored.
setAnchorCellXOffset(offset) OverGridImage Sets the horizontal pixel offset from the anchor cell.
setAnchorCellYOffset(offset) OverGridImage Sets the vertical pixel offset from the anchor cell.
setHeight(height) OverGridImage Sets the actual height of this image in pixels.
setWidth(width) OverGridImage Sets the actual width of this image in pixels.

Deprecated methods

MethodReturn typeBrief description
(削除) getUrl() (削除ここまで)StringGets the image's source URL.

Detailed documentation

assignScript(functionName)

Assigns the function with the specified function name to this image.

Parameters

NameTypeDescription
functionNameStringThe name of the function being specified. This must be a public top level function, not one ending in underscore such as privateFunction_.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getAltTextDescription()

Returns the alt text description for this image.

Return

String — The alt text description.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getAltTextTitle()

Returns the alt text title for this image.

Return

String — The alt text title.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getAnchorCell()

Returns the cell where an image is anchored.

Return

Range — The anchor cell.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getAnchorCellXOffset()

Returns the horizontal pixel offset from the anchor cell.

Return

Integer — The horizontal pixel offset.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getAnchorCellYOffset()

Returns the vertical pixel offset from the anchor cell.

Return

Integer — The vertical pixel offset.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getHeight()

Returns the actual height of this image in pixels. 

// Logs the height of all images in a spreadsheet
constimages=SpreadsheetApp.getActiveSpreadsheet().getImages();
for(leti=0;i < images.length;i++){
Logger.log(images[i].getHeight());
}

Return

Integer — The height of the image in pixels.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getInherentHeight()

Returns the inherent height of this image in pixels.

Return

Integer — The inherent height in pixels.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getInherentWidth()

Returns the inherent height of this image in pixels.

Return

Integer — The inherent width in pixels.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getScript()

Returns the name of the function assigned to this image.

Return

String — The name of the function.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getSheet()

Returns the sheet this image appears on. 

// Logs the parent sheet of all images in a spreadsheet
constimages=SpreadsheetApp.getActiveSpreadsheet().getImages();
for(leti=0;i < images.length;i++){
Logger.log(images[i].getSheet());
}

Return

Sheet — The sheet the image appears on.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

getWidth()

Returns the actual width of this image in pixels. 

// Logs the width of all images in a spreadsheet
constimages=SpreadsheetApp.getActiveSpreadsheet().getImages();
for(leti=0;i < images.length;i++){
Logger.log(images[i].getWidth());
}

Return

Integer — The width of the image in pixels.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

remove()

Deletes this image from the spreadsheet. Any further operation on the image results in a script error. 

// Deletes all images in a spreadsheet
constimages=SpreadsheetApp.getActiveSpreadsheet().getImages();
for(leti=0;i < images.length;i++){
images[i].remove();
}

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

replace(blob)

Replaces this image with the one specified by the provided BlobSource . The maximum supported blob size is 2MB.

Parameters

NameTypeDescription
blobBlobSource The new image as a Blob.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

replace(url)

Replaces this image with the one from the specified URL.

Parameters

NameTypeDescription
urlStringThe URL of the new image.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

resetSize()

Resets this image to its inherent dimensions.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

setAltTextDescription(description)

Sets the alt-text description for this image.

Parameters

NameTypeDescription
descriptionStringThe new alt text description for the image.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

setAltTextTitle(title)

Sets the alt text title for this image.

Parameters

NameTypeDescription
titleStringThe new alt text title for the image.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

setAnchorCell(cell)

Sets the cell where an image is anchored.

Parameters

NameTypeDescription
cellRange The new anchor cell.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

setAnchorCellXOffset(offset)

Sets the horizontal pixel offset from the anchor cell.

Parameters

NameTypeDescription
offsetIntegerThe new horizonal pixel offset.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

setAnchorCellYOffset(offset)

Sets the vertical pixel offset from the anchor cell.

Parameters

NameTypeDescription
offsetIntegerThe new vertical pixel offset.

Return

OverGridImage — This image, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

setHeight(height)

Sets the actual height of this image in pixels.

Parameters

NameTypeDescription
heightIntegerThe desired height in pixels.

Return

OverGridImage — The image for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

setWidth(width)

Sets the actual width of this image in pixels.

Parameters

NameTypeDescription
widthIntegerThe desired width in pixels.

Return

OverGridImage — The image for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

Deprecated methods

(削除) getUrl() (削除ここまで)

Deprecated. For most newly inserted images, the source URL is unavailable.

Gets the image's source URL. Returns an empty string if the URL is unavailable. For most newly inserted images, the source URL is unavailable regardless how the image is inserted.

Return

String — The image's source URL if available; returns an empty string otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2024年12月09日 UTC.