我正在尝试将值“ assetCell”传递给HTML对话框。看起来很简单。。。感谢您的任何帮助。
加油站
function Test(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var MySH = ss.getActiveSheet();
var Assetcell = MySH.getRange("f8").getValue()
var Assetcellb = MySH.getRange("f10").getValue()
var t = HtmlService.createTemplateFromFile('vIndex'); // Modified
t.AssetCell = Assetcell
t.AssetCell = Assetcellb
html = t.evaluate().setWidth(400).setHeight(300); // Added
SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
.showModalDialog(html, 'Hi');
}
的HTML
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<?!= AssetCell => ?>
</body>
</html>
这个修改怎么样?
function Test(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var MySH = ss.getActiveSheet();
var Assetcell = MySH.getRange("f8").getValue()
var t = HtmlService.createTemplateFromFile('vIndex'); // Modified
t.AssetCell = Assetcell; // Added
html = t.evaluate().setWidth(400).setHeight(300); // Added
SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
.showModalDialog(html, 'Hi');
}
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<?!= AssetCell ?> => <!-- Modified -->
</body>
</html>
如果这对您没有用,对不起。
<?!= AssetCell ?>
您可以使用相同的HTML。
var ss = SpreadsheetApp.getActiveSpreadsheet();
var MySH = ss.getActiveSheet();
var Assetcell1 = MySH.getRange("f8").getValue();
var Assetcell2 = MySH.getRange("f10").getValue();
var t = HtmlService.createTemplateFromFile('vIndex'); // Modified
t.AssetCell = [Assetcell1, Assetcell2]; // Added
html = t.evaluate().setWidth(400).setHeight(300); // Added
SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
.showModalDialog(html, 'Hi');
<?!= AssetCell1 ?>
和<?!= AssetCell2 ?>
时var ss = SpreadsheetApp.getActiveSpreadsheet();
var MySH = ss.getActiveSheet();
var Assetcell1 = MySH.getRange("f8").getValue();
var Assetcell2 = MySH.getRange("f10").getValue();
var t = HtmlService.createTemplateFromFile('vIndex'); // Modified
t.AssetCell1 = Assetcell1; // Added
t.AssetCell2 = Assetcell2; // Added
html = t.evaluate().setWidth(400).setHeight(300); // Added
SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
.showModalDialog(html, 'Hi');
的HTML
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<?!= AssetCell1 ?> => <!-- Modified -->
<?!= AssetCell2 ?> => <!-- Modified -->
</body>
</html>
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句