Google幻灯片自动更新链接/从Google工作表链接的表 [英] Google slides auto update links /tables linked from google sheet

问题描述

我有一个Google幻灯片演示文稿，其中包含一些链接到Google表格中数据的单元格/表格.当前，我必须手动单击每个链接的单元格/表以更新值. 我需要Google幻灯片的脚本，该脚本会自动更新/批处理更新/刷新这些链接，以便值/表能够自动更新.有可能吗?

解决方案

是和不是.

图表

是的！那些可以批量更新:

function onOpen() {

SlidesApp.getUi() // Or DocumentApp or FormApp.
    .createMenu('Update Charts')
    .addItem("Update now !!!!!", 'refreshCharts').addToUi();
}

function refreshCharts(){
    var gotSlides = SlidesApp.getActivePresentation().getSlides();

    for (var i = 0; i < gotSlides.length; i++) {
        var slide = gotSlides[i];
        var sheetsCharts = slide.getSheetsCharts();

        for (var k = 0; k < sheetsCharts.length; k++) {
            var shChart = sheetsCharts[k];
            shChart.refresh();
        }
    }
}

来源: https://stackoverflow.com/a/48254442/

形状/表格

否: https://issuetracker.google.com/issues/64027131

从Google更新2019年5月24日

https://gsuiteupdates.googleblog.com/2019/05/bulk-update-docs-slides.html

I have a Google Slides presentation that has some linked cells/table to data in Google Sheets. Currently, I have to manually click each linked cell/table to update values. I need a script for Google Slides that would auto-update / batch-update / refresh these links, so that the values/tables get auto-updated. Is that possible?

解决方案

Both yes and no.

Charts

Yes! those can be batch updated:

function onOpen() {

SlidesApp.getUi() // Or DocumentApp or FormApp.
    .createMenu('Update Charts')
    .addItem("Update now !!!!!", 'refreshCharts').addToUi();
}

function refreshCharts(){
    var gotSlides = SlidesApp.getActivePresentation().getSlides();

    for (var i = 0; i < gotSlides.length; i++) {
        var slide = gotSlides[i];
        var sheetsCharts = slide.getSheetsCharts();

        for (var k = 0; k < sheetsCharts.length; k++) {
            var shChart = sheetsCharts[k];
            shChart.refresh();
        }
    }
}

Source: https://stackoverflow.com/a/48254442/

Shapes/Tables

No: https://issuetracker.google.com/issues/64027131

Update From Google 24/5/2019

https://gsuiteupdates.googleblog.com/2019/05/bulk-update-docs-slides.html

这篇关于Google幻灯片自动更新链接/从Google工作表链接的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！