function main(spreadsheetReport) {
var sheet = spreadsheetReport.workbook.worksheets.get(0);
//获取图表,"图表 1"为图表的名称
var shape = sheet.shapes.get("图表 1");
var cells = sheet.cells;
//获取图表左上角的行号、右下角的行号、左上角的列号和右下角的列好,以确定需要设置背景色的单元格的范围
var upperLeftRow = shape.upperLeftRow;
var lowerRightRow = shape.lowerRightRow;
var upperLeftColumn = shape.upperLeftColumn;
var lowerRightColumn = shape.lowerRightColumn;
for (var i = upperLeftRow;
i <= lowerRightRow;
i++) {
//由于图形只占B到H列,A列和I列同样需要设置背景色,因此需要对范围进行增减1
for (var j = upperLeftColumn - 1;
j <= lowerRightColumn + 1;
j++) {
var cell = cells.get(i, j);
var style = cell.style;
style.foregroundColor = spreadsheetReport.getColor(242, 242, 242);
style.pattern = 1;
cell.style = style;
}
}
}