0
347
ViewsHow can I Update Spreadsheet cell value directly from Html Page using appscript
I have a Planning sheet with huge data. For every row will have 200+ columns (cells). I wanted to change the cell value from html page using appscript.
How can we change the cell value directly from Html Table view.
Please help.
Regards RS
·
Juan Pablo Isaza
1 answers
Answer question0
Update value of cell in Spreadsheet from HTML page
function updatecellvaluefromhtmlpage() {
let html = '<form><input type="text" name="thisvalue" size="25" placeholder = "Enter Value" /><br /><input type="button" value="Click to change value of A1 in Sheet1" onClick="google.script.run.changeValueOfA1(this.parentNode);" />'
SpreadsheetApp.getUi().showModelessDialog(HtmlService.createHtmlOutput(html),'Change Value Sheet1A1');
}
function changeValueOfA1(obj) {
const ss=SpreadsheetApp.getActive();
const sh = ss.getSheetByName('Sheet1');
sh.getRange('A1').setValue(obj.thisvalue)
}
Html Dialog:
Changed Cell:
·
Juan Pablo Isaza
Report
Answer question