限行数
限行数
提问于 2019-12-22 20:49:43
我有一个Google Sheet文档，它不断地添加数百行，减缓项目的速度，有时还会导致它崩溃。
是否有办法将行数限制为100行。我不想删除所有的空行，因为它是一个不断需要数据的日志，所以总是需要一个新的行。但是，对于每个文档，我们只使用大约100行。
我不确定这是由于我所附的脚本，还是仅仅是谷歌页面的一部分。
function setFormat() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
for (var i in sheets) {
var MaxRows = sheets[i].getMaxRows();
var MaxColumns = sheets[i].getMaxColumns();
sheets[i].getRange(2, 1, MaxRows, MaxColumns)
.setFontFamily('Arial')
.setFontSize('9')
.setFontStyle('normal')
.setFontColor('black')
.setVerticalAlignment('center')
.setBorder(true, true, true, true, true, true, "black", SpreadsheetApp.BorderStyle.SOLID);
sheets[i].getRange(1, 1, 1, MaxColumns)
.setFontFamily('Comfortaa')
.setFontSize('9')
.setFontStyle('bold')
.setFontColor('black')
.setVerticalAlignment('center')
.setBorder(true, true, true, true, true, true, "black", SpreadsheetApp.BorderStyle.SOLID);
sheets[i].autoResizeColumns(1, 1);
sheets[i].setColumnWidths(2, 1, 80);
sheets[i].setColumnWidths(3, 1, 75);
sheets[i].setColumnWidths(4, 1, 90);
sheets[i].setColumnWidths(5, 4, 45);
sheets[i].setColumnWidths(9, 3, 75);
sheets[i].setColumnWidths(12, 2, 130);
sheets[i].setColumnWidths(14, 1, 95);
sheets[i].setColumnWidths(15, 1, 100);
sheets[i].setColumnWidths(16, 1, 95);
sheets[i].setRowHeights(2, MaxRows-1, 15);
sheets[i].setRowHeights(1, 1, 16); }}和
function dataAlignment1() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var r = s.getRange(2, 1, lr, 2);
var set = r.setHorizontalAlignment('left');
}
function dataAlignment2() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var r = s.getRange(2, 3, lr, 1);
var set = r.setHorizontalAlignment('right');
}
function dataAlignment3() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var r = s.getRange(2, 4, lr, 1);
var set = r.setHorizontalAlignment('left');
}
function dataAlignment4() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var r = s.getRange(2, 5, lr, 4);
var set = r.setHorizontalAlignment('left');
}
function dataAlignment5() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var r = s.getRange(2, 9, lr, 2);
var set = r.setHorizontalAlignment('right');
}
function dataAlignment6() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var r = s.getRange(2, 11, lr, 1);
var set = r.setHorizontalAlignment('center');
}
function dataAlignment7() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var r = s.getRange(2, 12, lr, 4);
var set = r.setHorizontalAlignment('left');
}
function dataAlignment8() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var r = s.getRange(2, 16, lr, 1);
var set = r.setHorizontalAlignment('center');
}
function headerAlignment() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var lr = s.getLastRow();
var lc = s.getLastColumn();
var r = s.getRange(1, 1, 1, lc);
var set = r.setHorizontalAlignment('center');
}回答 1
Web Applications用户
发布于 2019-12-23 06:05:19
我认为您可以控制从脚本中插入的行数。您可以移除或附加到工作表中。据我所理解，您可以将每100行保存在文件中，也可以将最新的100行添加到文件的顶部，或者删除最老的行/将其保存在不同的工作表中，然后添加新行。
页面原文内容由Web Applications提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://webapps.stackexchange.com/questions/137333
复制相关文章
相似问题
腾讯云开发者
