使用Google Sheets API将图片插入Google Sheets单元格 [英] Insert image into Google Sheets cell using Google Sheets API

问题描述

在google apps脚本中，您可以使用insertImage函数(

In google apps Script you can insert an image into Google Spreadsheets using the insertImage function (https://developers.google.com/apps-script/reference/spreadsheet/sheet#insertimageblob-column-row).

但是我没有使用appscript.我正在使用Google Sheets API( https://developers.google. com/sheets/api/reference/rest/v4/spreadsheets )，但我似乎找不到找到这种方法的方法.有可能实现吗?

But I'm not using appscript. I'm using the Google Sheets API (https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets) and I can't seem to find a way to do this. Is there any possible implementation?

推荐答案

V4 API无法像Apps Script一样插入图像斑点(其中图像是工作表上的覆盖层，与任何内容都没有关联)细胞).您可以使用= IMAGE函数解决此问题.我们知道功能上的差距，并正在寻求增加对图像斑点的支持.

The V4 API doesn't have the ability to insert an image blob like Apps Script does (where the image is an overlay on the sheet, not associated with any cell). You may be able to workaround this using the =IMAGE function. We know of the gap in functionality and are looking into adding support for image blobs.

这篇关于使用Google Sheets API将图片插入Google Sheets单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！