Skip to content

Instantly share code, notes, and snippets.

@bernikr
Last active April 1, 2023 17:41
Show Gist options
  • Save bernikr/c8356b9928bbd027722e3d5adccea93d to your computer and use it in GitHub Desktop.
Save bernikr/c8356b9928bbd027722e3d5adccea93d to your computer and use it in GitHub Desktop.
function myFunction() {
const sheet = SpreadsheetApp.openById(<sheet id>);
const target_folder = DriveApp.getFolderById(<folder id>);
const folders = target_folder.getFolders();
while (folders.hasNext()) {
const f = folders.next();
f.setTrashed(true);
}
const slides = SlidesApp.create("temp");
for(const page of sheet.getSheets()){
var i = 0;
const charts = page.getCharts();
if(charts.length > 0){
const subfolder = target_folder.createFolder(page.getName());
for(const chart of charts){
const imageBlob = slides
.getSlides()[0]
.insertSheetsChartAsImage(chart)
.getAs("image/png");
subfolder.createFile(imageBlob.setName(`${(i+'').padStart(3,'0')}.png`));
i += 1;
}
}
}
DriveApp.getFileById(slides.getId()).setTrashed(true);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment