如何在Google表格中操作插入的对象？ [英] How do you manipulate an inserted object in Google Sheets?

问题描述

在工作表中插入一个对象（例如： https://developers.google.com/apps-script/reference/spreadsheet/sheet#insertImage（String，Integer，Integer））：

Insert an object in sheets (ex: https://developers.google.com/apps-script/reference/spreadsheet/sheet#insertImage(String,Integer,Integer)):

var obj = sheet.insert{ObjectType}(args.);

您可以在表格中调用图表：

You can call your charts in sheets:

var chart = sheet.getCharts()[0].modify().{params}.build;

可以在文档中调用对象：

And can call objects in docs:

docs.getBody().findElement(DocumentApp.ElementType.{object type}, null);

在sheet中查找对象的等价物是什么，也就是说有一个gsheets dom模型，就像docs ？或者是非图表对象无法通过gAppscript访问？

What's the equivalent for finding objects in sheets, i.e. is there a gsheets dom model like there is for docs? or are non-chart objects inaccessible through gAppscript?

//get objects in sheet    
var obj2 = sheet.getObject()[0]
//error, method doesn't exist
//
//get objects near a range
var obj3 = sheet.getRange(x,y).getObject()
//error

推荐答案

也许我在这里错过了一些东西，但Sheets中的数据的组织方式与Docs中的不同。你想找什么样的物体？我认为你应该能够通过 getRange ， getValues ，和setValues。

Maybe I'm missing something here, but data in Sheets isn't organized the same way it is in Docs. What kind of "objects" are you trying to find? I think you should be able to retrieve and manipulate most anything with a combination of getRange, getValues, and setValues.

这篇关于如何在Google表格中操作插入的对象？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！