使用find()
method中的DeveloperMetadataFinder
class。
这是一个简单的例子:
function addMetadata() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = spreadsheet.getActiveSheet();
var range = sheet.getRange('1:1');
sheet.addDeveloperMetadata('sheet');
spreadsheet.addDeveloperMetadata('spreadsheet');
range.addDeveloperMetadata('range');
}
function getMetadata() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var metadataFinder = spreadsheet.createDeveloperMetadataFinder();
results = metadataFinder.find();
for (var i = 0; i < results.length; i++) {
Logger.log('id: ' + results[i].getId() + ',key: ' + results[i].getKey());
}
}
运行addMetadata()
用3个元数据实例填充新的电子表格后,这是运行getMetadata()
的日志输出:
[19-11-12 08:34:54:874 PST] id: 375645033,key: spreadsheet
[19-11-12 08:34:54:875 PST] id: 802864327,key: range
[19-11-12 08:34:54:875 PST] id: 569198748,key: sheet
本文链接:https://www.f2er.com/3115939.html