如果我使用Google App Script链接到缩略图图像，如何在Google SpreadSheet中显示缩略图图像？ [英] How to display Thumbnail image in Google SpreadSheet if i have a link to the thumbnail image using Google App Script?

问题描述

我正在实施Google Apps脚本并尝试在Google Spread Sheet中显示数据。我能够正确显示文本数据，但是我想要在电子表格单元格中显示一个视频的缩略图URL。即我想显示对应于我在我的Java脚本变量/对象中的URL的缩略图。

我也指链接，（[https：// developers.google.com/apps-script/guides/sheets#writing]）。

我该怎么做。任何帮助或建议，将不胜感激。感谢。

解决方案

使用脚本将公式写入单元格，如= IMAGE $ b

I am implementing the Google Apps Script and trying to display data in the Google Spread Sheet . I am able to display textual data properly, but i have a thumbnail URL of a video which i want to display in the spread sheet cell. i.e. i want to display the thumbnail image corresponding to a URL i have in my java script variable / object.

I am also referring the link, ([https://developers.google.com/apps-script/guides/sheets#writing]).

How can i do this. Any help or suggestion would be appreciated. Thanks.

解决方案

Use the script to write a formula to a cell as in =IMAGE(url)

这篇关于如果我使用Google App Script链接到缩略图图像，如何在Google SpreadSheet中显示缩略图图像？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！