这次修改怎么样?
天然气
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');
}
HTML
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<?!= AssetCell ?> => <!-- Modified -->
</body>
</html>
参考号:
如果这对你没用,我很抱歉。
编辑:
1、当你想把它们送给
<?!= 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');
2、当你想给予
<?!= 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>
