Google-sheets – Is it possible to paste local images in Google Spreadsheet

databasegoogle sheets

I am wondering if this is possible in Google Sheets.

I am trying to create a visual database of products in the form of a shared spreadsheet. The images cannot be online for privacy and trade secret reasons.

So far I have been using Apple Numbers which allows this through drag and drop or copy paste functions.

This is more or less what it should look like:

I haven't found recent or clear explanations about this when I searched.

Best Answer

The term used on the Google Docs Editors Help Center are "insert" and "add".

From Insert or delete images or videos:

Add an image

Open a document, spreadsheet, or presentation in Google Docs, Sheets, or Slides.

Click Insert and then Image.

Select from the following options:

Upload: Choose an image from your computer and click Open.

Take a snapshot: Use your webcam and click Take a snapshot.

By URL: Paste the URL of an image from the web and click Select.

Your albums: Choose an image from one of your photos albums stored on the web and click Select.

Google Drive: Choose an image stored in Google Drive and click Select.

Search: Choose an image from the stock photography archive, or the Google and Life archives, and click Select.

Your image will be added to your file.

Code

function onEdit(e) {
  // allow book name to be added
  var cell = e.range.getA1Notation();  
  if(cell == "A7") {
    return;
  }

  // only if conditional color is present
  var color = e.range.getBackground(); 
  if(cell != "A7" && (color == "#cfe2f3" || color == "white")) {
    var first = e.range.offset(-1,-1).getValue(); 
    var second = e.range.offset(-1,0).getValue();

    // first entry
    if(typeof first == "string" && second == "Current") {
      return;
    } 

    // non consecutive weeks
    if(typeof first == "number" && typeof second == "string") {
      respond(e, "Not consecutive enty !!");
    } 

    // out of range  
    if(first == "") {
      respond(e, "This entry is out of range");
    }
  } else {
    respond(e, "Out of bounds");
  }
}

function respond(e, text) {
  e.range.clearContent();
  e.source.toast(text);
  return;
}

Example

I've created an example file for you: Copy of Reading scheduler. See also revised code for removing data.

Best Answer

Add an image

Related Solutions

Google-sheets – Entering local date on Google Sheets

Google-sheets – Is it possible to prevent people from entering data into the Google Spreadsheet

Code

Example

Related Topic