根据要在新创建的电子表格中插入图表的方式,我有两种使用Sheet [1]和EmbeddedChart [2]方法的解决方案:
1)如果要在插入图表之前将图表转换为图像:
function AuswertungTest() {
//Sheet with diagram
var sheet = SpreadsheetApp.getActiveSheet();
//Create new Spreadsheet in Drive and get its first Sheet
var newSpreadsheet = SpreadsheetApp.create("new spreadsheet");
var newSheet = newSpreadsheet.getSheets()[0];
//Get the first chart and convert it to an image blob
var chart = sheet.getCharts()[0];
chart = chart.getAs('image/jpeg');
//Insert image in new spreadsheet
newSheet.insertImage(chart,2,2)
};
2)如果您想按原样插入图表(图表将取决于新电子表格中的数据):
function AuswertungTest() {
//Sheet with diagram
var sheet = SpreadsheetApp.getActiveSheet();
//Create new Spreadsheet in Drive and get its first Sheet
var newSpreadsheet = SpreadsheetApp.create("new spreadsheet");
var newSheet = newSpreadsheet.getSheets()[0];
//Get the first chart and modify it to set the wanted position
var chart = sheet.getCharts()[0];
chart = chart.modify().addRange(newSheet.getRange("A1:B8")).setPosition(2,0).build();
//Insert chart in new spreadsheet
newSheet.insertChart(chart);
};
[1] https://developers.google.com/apps-script/reference/spreadsheet/sheet
[2] https://developers.google.com/apps-script/reference/spreadsheet/embedded-chart
本文链接:https://www.f2er.com/3125885.html