0

Is it possible to add an html element directly into google sheets cells using google apps script? I have a tasks list in my minitask.html that I would like to add into my google sheet. I have a large merged cell where I would like to add the element (B39:I71). I haven't been able to find a way to add it directly into my merged cell.

The best solution I have found that gets the task list somewhat on to my sheet is by adding a sidebar of the element.

function onOpen() {
  SpreadsheetApp.getUi() 
      .createMenu('Tasks')
      .addItem('Mini Tasks', 'showSidebar')
      .addToUi();
}

function showSidebar() {
  var html = HtmlService.createHtmlOutputFromFile('minitask')
      .setTitle('Mini Tasks');
  SpreadsheetApp.getUi()
      .showSidebar(html);
}
user6738171
  • 1,009
  • 2
  • 15
  • 50
  • 1
    If you mean one that will be rendered, then the answer is no. But you could add the the value with sheet.getRange().setValue() – Cooper Feb 01 '23 at 17:45
  • Related: https://stackoverflow.com/questions/55650581 (not a single cell) – TheMaster Feb 01 '23 at 18:02

0 Answers0