Office.js Excel:格式化并写入可见单元格

Excel.run(function(context) {
   // 在此处编写代码
});

var sheet = context.workbook.worksheets.getActiveWorksheet();

var range = sheet.getRange("A1:B2");

range.format.fill.color = "red";
range.format.font.bold = true;

range.values = [["数据1", "数据2"], ["数据3", "数据4"]];

Excel.run(function(context) {
    var sheet = context.workbook.worksheets.getActiveWorksheet();
    var range = sheet.getRange("A1:B2");
    range.format.fill.color = "red";
    range.format.font.bold = true;
    range.values = [["数据1", "数据2"], ["数据3", "数据4"]];
    return context.sync();
}).catch(function(error) {
    console.log(error);
});