小贝子编程

带Apps脚本变量的引导进度条



我在Apps Script中有这个Google Sheet单元格计数器，我不知道如何设置引导进度条与"百分比"变量。

GS

function cellCounter() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
var cells = 0;
sheets.forEach(function(sheet){
cells = cells + sheet.getMaxRows() * sheet.getMaxColumns();
});
var division = cells/10000000*100;
var percentage = +division.toFixed(0);
return ( "📈 Cada documento de Google Sheets tiene capacidad para diez millones de celdas. Has usado el <strong>" + percentage + "%</strong> del total con <strong>" + cells + " celdas</strong>." );
}


<div class="progress">
<div class="progress-bar progress-bar-striped progress-bar-animated" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" style="width: 75%"></div>
</div>

使用强制打印脚本

  • 这允许您通过应用程序脚本变量为html语法<?!= ... ?>
  • 要传递的变量必须全局声明

web应用程序示例(请根据需要将其调整为您的对话框):

GS

let size;

function doGet() {
size = cellCounter();
return HtmlService.createTemplateFromFile("html.html").evaluate();
}

function cellCounter() {

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
var cells = 0;
sheets.forEach(function(sheet){
cells = cells + sheet.getMaxRows() * sheet.getMaxColumns();
});
var division = cells/10000000*100;
var percentage = +division.toFixed(0);
return percentage;
}

html.html:

<!DOCTYPE html>
<html>
<head>
<base target="_top">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</head>
<body>
<div class="progress">
<div class="progress-bar progress-bar-striped progress-bar-animated" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" style="width: <?!= size ?>%">Hello </div>
</div>
</body>
</html>

相关内容

最新更新


热门标签：

javascript python java c# php android html jquery c++ css ios sql mysql arrays asp.net json python-3.x ruby-on-rails .net sql-server django objective-c excel regex ruby linux ajax iphone xml vba spring asp.net-mvc database wordpress string postgresql wpf windows xcode bash git oracle list vb.net multithreading eclipse algorithm macos powershell visual-studio image forms numpy scala function api selenium