Breaking News: Grepper is joining You.com. Read the official announcement!

for resize img by app script

Ashikur Rahman SA answered on August 16, 2022 Popularity 1/10 Helpfulness 1/10

answer for resize img by app script

for resize img by app script

Comment

function InsertImageTest() {
  var ReportSpeadsheet = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/the-file-id/edit#gid=0");
  var ReportSheet = ReportSpeadsheet.getSheetByName("Sheet1");

  // --- I modified below script.
  var fileIds = ["fileId1", "fileId2"];  // <--- Please set the file IDs of the image files.
  fileIds.forEach((id, i) => {
    var obj = Drive.Files.get(id);
    var image = obj.imageMediaMetadata && (obj.imageMediaMetadata.width * obj.imageMediaMetadata.height) > 1048576 ? obj.thumbnailLink.replace(/=s\d+/, "=s500") : DriveApp.getFileById(id).getBlob();
    ReportSheet.insertImage(image, 1, i + 1);
  });
}

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: stackoverflow.com

Tags: javascript resize script

Link to this answer
Share Copy Link