LiveOverflow

andrewroberts

function exportSpreadsheet() {
 
  //All requests must include id in the path and a format parameter
  //https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export
 
  //FORMATS WITH NO ADDITIONAL OPTIONS
  //format=xlsx       //excel
  //format=ods        //Open Document Spreadsheet
  //format=zip        //html zipped          
  

tanaikech

Limitation of Images for Inserting to Spreadsheet using Google Apps Script

Introduction

Here I would like to introduce about the limitation of images for inserting to Spreadsheet using Google Apps Script (GAS). When you want to insert the images to Spreadsheet using GAS, insertImage() of class Sheet is usually used for this situation. At this time, an error sometimes occurs. This indicates that there is the limitation for inserting images to Spreadsheet. So I investigated the limitation.

As a result, it was found that the limitation depends on the image area (pixels^2) rather than the file size of it. The maximum area of image which can be inserted was 1,048,576 pixels^2.

Experiment

In order to investigate the limitation, I have converged the condition by changing the file size and the image size. By this, it was found that the limitation depends on the image area (pixels^2) rather than the file size of it. For this confirmation, I can show you the following experimental data.

hotpaw2

//
//  MyMetalWaterfall.swift
//    version 0.1.105 (updated for Swift 5)
//
//  Demonstrates using a MetalKit compute shader to render a live waterfall RGB bitmap
//    into a UIView
//
//  This is a single file iOS app
//
//  It includes AppDelegate for a minimal demonstration app

eleev

 func getURL(ofPhotoWith mPhasset: PHAsset, completionHandler : @escaping ((_ responseURL : URL?) -> Void)) {
        
        if mPhasset.mediaType == .image {
            let options: PHContentEditingInputRequestOptions = PHContentEditingInputRequestOptions()
            options.canHandleAdjustmentData = {(adjustmeta: PHAdjustmentData) -> Bool in
                return true
            }
            mPhasset.requestContentEditingInput(with: options, completionHandler: { (contentEditingInput, info) in
                completionHandler(contentEditingInput!.fullSizeImageURL)
            })

AshHeskes

{
	".123"			: "application/vnd.lotus-1-2-3",
	".3dml"			: "text/vnd.in3d.3dml",
	".3g2"			: "video/3gpp2",
	".3gp"			: "video/3gpp",
	".a"			: "application/octet-stream",
	".aab"			: "application/x-authorware-bin",
	".aac"			: "audio/x-aac",
	".aam"			: "application/x-authorware-map",
	".aas"			: "application/x-authorware-seg",